See Also Properties Methods
A part of a recordset The Value property of a Field object contains data from a single element of that column from the current record . that defines one column of data.
Field objects are stored with a TableDef in a Database, and like a Table, a Field has a name that is recognized by the Database. The default collection of a recordset is the Fields collection. You can simplify your code by taking advantage of defaults. For example, both of the following code lines print the value of the "PubID" Field in the current record of a data control:
The Name property of a Field object is not the same as the name of an object variable Unlike forms and controls, the Name property of data access objects is available at run time. to which it is assigned.
In the Professional Edition, you can declare an object variable as type Fields (a collection), or as a type Field. You could use this code to print out the value of the "PubID" Field for each record in a Dynaset:
Dim MyDb As Database, MyDn As Dynaset, MyFd As Field
Set MyDb = OpenDatabase("BIBLIO.MDB")
Set MyDn = MyDb.CreateDynaset("Publishers")
Set MyFd = MyDb("PubID")
Do While Not MyDn.EOF