O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

E.7. Fields Collection

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.

E.7.1. Properties of the Fields Collection

The Fields collection supplies only two properties: Count and Item, which are detailed in the following table.

PropertyDataTypeDescription
CountLongThe number of Field objects in the Record or Recordset object.
ItemFieldIdentifies the position of the current record in the Recordset.

E.7.2. Methods of the Fields Collection

Methods for the Fields collection are described in the following table.

MethodDescription
AppendCreates and adds a field object to the Fields collection.
UpdateFinalizes any additions or deletions to the Fields collection.
CancelUpdateCancels any pending changes for a record.
DeleteDeletes a Field from the collection.
RefreshRefreshes the Fields collection.
ResyncResynchronizes the current record.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required