DefinedSize

Syntax	long = fieldobject.DefinedSize
Description	Returns a long value that is the defined (maximum possible) size (data capacity) of a Field object. The DefinedSize property returns a long value that is the defined or maximum size in bytes of a Field object. Size can also be referred to as data capacity. The DefinedSize property has read/write permission when being used to create recordsets, but converts to read-only when you open an already created recordset. The companion ActualSize property sets or returns a long value that is the actual length of a Field object value. In other words, DefinedSize defines how long a value can be, while ActualSize telling how long it really is.
See Also	Field, ActualSize.
Example	Dim rsData As Object Set rsData = Server.CreateObject("ADODB.Recordset") rsData.Open "DataList", strConnection, , , adCmdTable rsData.MoveFirst Do While Not rsData.EOF Debug.Print "Actual Size = " & rsData(strFieldName).ActualSize Debug.Print "Defined Size = " & rsData(strFieldName).DefinedSize rsData.MoveNext Loop