Field Object

A Field object represents a column of data with a common data type and a common set of properties.

Remarks

The Fields collections of Index, QueryDef, Relation, and TableDef objects contain the specifications for the fields those objects represent. The Fields collection of a Recordset object represents the Field objects in a row of data, or in a record. You use the Field objects in a Recordset object to read and set values for the fields in the current record of the Recordset object.

In both Microsoft Jet and ODBCDirect workspaces, you manipulate a field using a Field object and its methods and properties. For example, you can:

• Use the OrdinalPosition property to set or return the presentation order of the Field object in a Fields collection. (This property is read-only for ODBCDirect databases.)
  
  
• Use the Value property of a field in a Recordset object to set or return stored data.
  
  
• Use the AppendChunk and GetChunk methods and the FieldSize property to get or set a value in an OLE Object or Memo field of a Recordset object.
  
  
• Use the Type, Size, and Attributes properties to determine the type of data that can be stored in the field.
  
  
• Use the SourceField and SourceTable properties to determine the original source of the data.

In Microsoft Jet workspaces, you can:

• Use the ForeignName property to set or return information about a foreign field in a Relation object.
  
  
• Use the AllowZeroLength, DefaultValue, Required, ValidateOnSet, ValidationRule, or ValidationText properties to set or return validation conditions.
  
  
• Use the DefaultValue property of a field on a TableDef object to set the default value for this field when new records are added.

In ODBCDirect workspaces, you can:

• Use the Value, VisibleValue, and OriginalValue properties to verify successful completion of a batch update.

Note For a complete list of all methods, properties, and collections available on a Field object in any database or connection, see the Summary topic.

To create a new Field object in an Index, TableDef, or Relation object, use the CreateField method.

When you access a Field object as part of a Recordset object, data from the current record is visible in the Field object's Value property. To manipulate data in the Recordset object, you don't usually reference the Fields collection directly; instead, you indirectly reference the Value property of the Field object in the Fields collection of the Recordset object.

To refer to a Field 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 Field object that you create and append to a Fields collection. The context of the field reference will determine whether you are referring to the Field object or the Value property of the Field object.