Name
Field Object — (Versions 2.0, 2.1, 2.5, 2.6)
Synopsis
Dim field As ADODB.FieldThe Field object represents an individual column within a Recordset or a Record object’s Fields collection. A Field contains metadata properties that define its datatype, size, and precision.
Applies To
- Fields
Contains a group of Field objects that represent the fields of the current record in an open Recordset object.
Collections
- Properties
Contains characteristics specific to the Field object for the currently used provider.
Methods
- AppendChunk
Appends data to a large data or binary field.
- GetChunk
Returns the specified number of bytes or characters from the specified field.
Properties
- ActualSize
Returns the actual length of a field’s value.
- Attributes
Sets or returns specific characteristics about the Field object.
- DataFormat
The DataFormat property for the Field object is not documented at all in the ADO help files -- however, the DataFormat property is used in other Microsoft objects outside of ADO.
- DefinedSize
Represents the size, in bytes, of the capacity of a Field object’s datatype.
- Name
Specifies the name for the current Field object.
- NumericScale
Indicates the scale of numeric values in the current Field object.
- OriginalValue
Returns the value that belonged to a field before any changes were made to it.
- Precision
Represents the degree of precision of a numeric value within the current Field object.
- Status
Indicates the status of the current Field object.
- Type
Indicates the datatype of the Field’s Value property.
- UnderlyingValue ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access