The Fields collection contains all the Field objects of a Recordset or Record object. It allows you to retrieve information about the field as well as data within the field. The following sections describe the properties and methods for the Fields collection. There are no collections for the Fields collection.
The Fields collection supplies only two properties: Count and Item, which are detailed in the following table.
|Count||Long||The number of Field objects in the Record or Recordset object.|
|Item||Field||Identifies the position of the current record in the Recordset.|
Methods for the Fields collection are described in the following table.
|Append||Creates and adds a field object to the Fields collection.|
|Update||Finalizes any additions or deletions to the Fields collection.|
|CancelUpdate||Cancels any pending changes for a record.|
|Delete||Deletes a Field from the collection.|
|Refresh||Refreshes the Fields collection.|
|Resync||Resynchronizes the current record.|