Field Object

Each recordset you create is made up of a collection of Field objects. A Field object represents the data from a specific column in the query or table called from the data provider by the ADO application. All the data in a given field in the recordset has the same data type. The Value property of the Field object represents the actual field value for that field in the current record.

The Field object allows you to view or change the data in a field of a record in your recordset. Table 12.10, Table 12.11, and Table 12.12 list its properties, collections, and methods, respectively.

Table 12.10. Field Object Properties




A long that represents the size of the field's value in number of characters. Some data providers allow the user to set this property to reserve space for BLOB data. However, most often this is a read-only property.


Allows you to retrieve several different characteristics of the Field object, such as whether the data for a field is retrieved with the rest of the record or only when you specifically use the field, whether you can change the value of the field, etc. This is a read-only property.


The size of the Field object. This is different from the ActualSize property. The value of the ActualSize property could indicate that the length of the value in a Field object is one character, but the value of the DefinedSize property could be larger. You can use DefinedSize to determine if a ...

Get ASP in a Nutshell, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.