ActualSize Property

Indicates the actual length of a field's value.

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 (-1).

The ActualSize and DefinedSize properties are different as shown in the following example: a Field object with a declared type of adChar 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.