Access™ 2007 VBA Programmer's Reference

E.8. Field Object

The Fields collection contains Field objects. Each object represents an individual field within a Fields collection from an ADO Record or Recordset object.

E.8.1. Properties of the Field Object

The properties for the Field object are described in the following table.

Property	DataType	Description
ActualSize	Long	Returns the actual size of the value of the field.
Attributes	Long	Describes certain characteristics of the field.
DataFormat	Object	Can be used to format your data.
DefinedSize	Long	Describes the defined size for the field.
Name	String	Contains the name of the field.
NumericScale	Byte	Number of digits allowed to the right of the decimal point for a numeric field.
OriginalValue	Variant	Stores the original value for the field.
Precision	Byte	Indicates the precision for numeric data.
Status	FieldStatusEnum	Determines whether the field has been successfully added to the collection.
Type	Byte	Lists the data type for the field.
UnderlyingValue	Variant	Lists the most recently retrieved value for the field.
Value	Variant	Contains the field's current value.

E.8.2. Methods of the Field Object

The Field object has two methods, which are detailed in the following table. These methods apply only to string or binary field types and may not be supported by all ADO providers.

Method	Description
AppendChunk	Allows data to be appended to a string or binary field type.
GetChunk	Allows retrieval of data from a string or binary field type.

E.8.3. Collection of the Field Object

The only collection of the Field ...