Access Database Design and Programming, Second Edition

Field Object

Collections

Property	Type	Version	Description
Properties	Properties	3.0/3.5	Collection of Property objects

Methods

Method	Parameters	Returns	Version	Description
AppendChunk	Val	Sub	3.0/3.5	Writes long binary data to a field
CreateProperty	[Name], [Type], [Value], [DDL]	Property	3.0/3.5	Creates a new user-defined Property object
FieldSize		Long	3.0	Returns the field size field
GetChunk	Offset As Long, Bytes As Long	Byte	3.0/3.5	Reads binary data from a field

Properties

Property	Type	Version	Description
AllowZeroLength	Boolean	3.0/3.5	Indicates whether a zero-length string is valid for this field
Attributes	Long	3.0/3.5	Value indicating characteristics of this Field object
CollatingOrder	Long	3.0/3.5	Language used for sorting and comparisons
DataUpdatable	Boolean	3.0/3.5	Indicates whether the data in the field are updatable
DefaultValue	String	3.0/3.5	Default value of the field for a new record
FieldSize	Long	3.5	The size of a memo field or a long binary field
ForeignName	String	3.0/3.5	The name of the foreign field
Name	String	3.0/3.5	The name of this Field object
OrdinalPosition	Integer	3.0/3.5	The relative position of this field object
OriginalValue	Variant	3.5	Value stored in the database server at the start of a batch update
Required	Boolean	3.0/3.5	Indicates whether the Field requires a non-Null value
Size	Long	3.0/3.5	Maximum size of the field
SourceField	String	3.0/3.5	Name of ...