D.8. The Field Object
The Fields collection contains Field objects. Each object represents an individual field within an ADO Recordset.
D.8.1. Properties of the Field Object
The properties for the Field object are listed in the following table.
Property | Data Type | Description |
---|---|---|
ActualSize | Long | Returns the actual size of the value of the field |
Attributes | Long | Describes certain characteristics of the field |
DataFormat | Object | Can be used to format your data |
DefinedSize | Long | Describes the defined size for the field |
Name | String | Contains the name of the field |
NumericScale | Byte | Number of digits allowed to the right of the decimal point for a numeric field |
OriginalValue | Variant | Stores the original value for the field |
Precision | Byte | Indicates the precision for numeric data |
Status | FieldStatusEnum | Determines whether the field has been successfully added to the collection |
Type | Byte | Lists the data type for the field |
UnderlyingValue | Variant | Lists the most recently retrieved value for the field |
Value | Variant | Contains the field's current value |
There are two methods available for the Field object. AppendChunk allows you to append data to a large string or binary field. GetChunk allows you to retrieve data from a large string or binary field.
Collections for the Field Object | Description |
---|---|
Properties | Contains all the property objects for the current command object |
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.