Using Field Objects

The default collection of a Recordset object is its Fields collection. This collection includes a single Field object corresponding to each field (or column) in the Recordset object. Each Field object has a set of properties uniquely identifying the field’s name, data type, and so on, as well as the value of the field in the current record.