Field2 Object
| Access Developer Reference |
A Field2 object represents a column of data with a common data type and a common set of properties.
Remarks
A Field2 object is contains all of the same properties and methods as the Field object. The Field2 object contains several new properties and methods that support multi-valued field types. The new properties and methods are:
- AppendOnly property
- ComplexType property
- IsComplex property
- LoadFromFile method
- SaveToFile method
To refer to a Field2 object in a collection by its ordinal number or by its Name property setting, use any of the following syntax forms:
Fields(0)
Fields("name")
Fields![name]
With the same syntax forms, you can also refer to the Value property of a Field2 object that you create and append to a Fields collection. The context of the field reference will determine whether you are referring to the Field2 object or the Value property of the Field object.