D.7. The Fields Collection
The collection contains all the field objects of a Recordset or Record object. The Fields collection has only two properties you'll use: the Count property, which returns the number of Field objects in the collection; and the Item property, which returns a specific field in the collection.
D.7.1. Methods of the Fields Collection
Methods for the Fields collection are listed in the following table.
| Method | Description |
|---|---|
| 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 |
Get Access 2003 VBA Programmer's Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
