A Fields collection contains all stored CdbField objects of a CdbIndex, CdbQueryDef, CdbRecordset, CdbRelation, or CdbTableDef object.
Remarks
The Fields collections of the CdbIndex, CdbQueryDef, CdbRelation, and CdbTableDef objects contain the specifications for the fields those objects represent. The Fields collection of a CdbRecordset object represents the CdbField objects in a row of data or in a record. Use the CdbField objects in a CdbRecordset object to read and to set values for the fields in the current record of the CdbRecordset object.
To refer to a CdbField object in a collection by its ordinal number or by its Name property setting, use either of the following syntax forms:
Fields[0]
Fields["name"]
With the same syntax forms, you can also refer to the Value property of a CdbField object that you create and append to a Fields collection. The context of the field reference will determine whether you are referring to the CdbField object or the Value property of the CdbField object.