O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

PropertyDataTypeDescription
ActualSizeLongReturns the actual size of the value of the field.
AttributesLongDescribes certain characteristics of the field.
DataFormatObjectCan be used to format your data.
DefinedSizeLongDescribes the defined size for the field.
NameStringContains the name of the field.
NumericScaleByteNumber of digits allowed to the right of the decimal point for a numeric field.
OriginalValueVariantStores the original value for the field.
PrecisionByteIndicates the precision for numeric data.
StatusFieldStatusEnumDetermines whether the field has been successfully added to the collection.
TypeByteLists the data type for the field.
UnderlyingValueVariantLists the most recently retrieved value for the field.
ValueVariantContains 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.

MethodDescription
AppendChunkAllows data to be appended to a string or binary field type.
GetChunkAllows retrieval of data from a string or binary field type.

E.8.3. Collection of the Field Object

The only collection of the Field ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required