Skip to content

Latest commit

 

History

History
33 lines (28 loc) · 1.56 KB

actualsize-property-ado.md

File metadata and controls

33 lines (28 loc) · 1.56 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords apitype
ActualSize Property (ADO)
ActualSize Property (ADO)
rothja
jroth
03/20/2018
sql
ado
reference
Field20::ActualSize
ActualSize property [ADO]
COM

ActualSize Property (ADO)

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

Field Object

See Also

ActualSize and DefinedSize Properties Example (VB)
ActualSize and DefinedSize Properties Example (VC++)
DefinedSize Property