Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Indicates the actual length of a field's value in bytes.
Settings and Return Values
Returns a Long value.
Remarks
Use the ActualSize property to return the actual length of a Field object's value. For all fields, the ActualSize property is read-only. If ADO cannot determine the length of the Field object's value, the ActualSize property returns adUnknown.
The ActualSize and DefinedSize properties are different, as shown in the following example. A Field object with a declared type of adVarChar and a maximum length of 50 characters returns a DefinedSize property value of 50, but the ActualSize property value it returns is the length of the data stored in the field for the current record. Fields with a DefinedSize greater than 255 bytes are treated as variable length columns.
Applies To
See Also
ActualSize and DefinedSize Properties Example (VB)
ActualSize and DefinedSize Properties Example (VC++)
DefinedSize Property