See Also Example
Returns the number of bytes in a text or binary field.
sizevar = fieldobject.FieldSize( )
The FieldSize method uses these parts:
sizevar A variable of Long or Variant data type.
fieldobject A field of Memo or Long Binary field data type (not valid on fields of other field data types). Can be a member of the Fields collection in a recordset. In the Professional Edition, can also be an object variable identifying a Field in a recordset.
Since a binary field can be very large, always assign the value returned by FieldSize to a variable of Long or Variant data type.
You can use FieldSize with the AppendChunk and GetChunk methods to manipulate large fields.
An error occurs if you use FieldSize with fields other than Memo or Long Binary field data types.