ADODB Object

ActualSize

 
Syntax
 
long = fieldobject.ActualSize
fieldobject.ActualSize = long
 
Description
Returns a long value that is the actual length of a Field object's value.
 
The ActualSize property sets or returns a long value that is the actual length of a Field object value. If ADO cannot determine the length, this property will return adUnknown.
 
The companion property, DefinedSize, is used to set the maximum size of a value In other words, DefinedSize defines how long a value can be, while ActualSize telling how long it really is.
See Also
Field, DefinedSize.
Example
 
Set rsData = Server.CreateObject("ADODB.Recordset")
rsData.Open "GuruList", strConnection, , , adCmdTable
rsData.MoveFirst
Do While Not rsData.EOF
   Debug.Print "Actual Size = " & rsData(strFieldName).ActualSize & vbNewline
   Response.Write "Defined Size = " & rsData(strFieldName).DefinedSize & vbNewline
   rsData.MoveNext
Loop