ADO DefinedSize and ActualSize Properties

The DefinedSize property returns a long value that indicates the defined size of a field (in bytes).

The ActualSize property is a read-only property. It returns a long value that indicates the actual length of a field's value.

If ADO cannot determine the length of the Field object's value, it returns adUnknown.

The DefinedSize property defines how long a field's value can be, while ActualSize tells how long it really is.

Syntax

objrs.Fields(number).DefinedSize

objrs.Fields(number).ActualSize

Example

Dim conn As ADODB.Connection
Dim rs As Recordset

Set conn = New ADODB.Connection
conn.Provider = "Microsoft.Jet.OLEDB.4.0"
conn.Open "F:\MaterialMaster\Material_Master.mdb"

Set rs = New ADODB.Recordset
rs.Open "SELECT * FROM tblAMSEA", conn
Debug.Print(rs.Fields(0).DefinedSize)
Debug.Print(rs.Fields(0).ActualSize)

rs.Close
conn.Close