FieldSize Method

See AlsolanFieldSizeSee                 ExamplelanGetChunkEx>Low


Returns the number of bytes in a text or binary field.


sizevar = fieldobject.FieldSize( )


The FieldSize method uses these parts:

Part                 Description


sizevar             A variable of Long1DDU1E5 or Variant8PHEAW3 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 variableZ3R9Q5 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.