A Field object represents a column of data with a common data type.
Collections
Methods
Properties
ActualSize, Attributes, DefinedSize, Name, NumericScale, OriginalValue, Precision, Type, UnderlyingValue, Value
Remarks
A Recordset object has a Fields collection made up of Field objects. Each Field object corresponds to a column in the Recordset. You use the Value property of Field objects to set or return data for the current record. Depending on the functionality the provider exposes, some collections, methods, or properties of a Field object may not be available.
With the collections, methods, and properties of a Field object, you can do the following:
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:
recordset.Fields.Item(0)
recordset.Fields.Item("name")
recordset.Fields(0)
recordset.Fields("name")
recordset(0)
recordset("name")
recordset![name]
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.