See Also Example
Description
Returns the number of bytes in a text or binary field.
Syntax
sizevar = fieldobject.FieldSize( )
Remarks
The FieldSize method uses these parts:
Part Description
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.