See Also Example
Returns all or a portion of a Memo or Long Binary field in a specified recordset.
stringvar = fieldobject.GetChunk( offset, numbytes )
The GetChunk method uses these parts:
stringvar A variable of type String or Variant that will receive the data from the field named by fieldobject.
fieldobject A field of Memo or Long Binary type (not valid on fields of other field data types). It 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.
offset Numeric expression for the number of bytes to skip before copying begins.
numbytes Numeric expression for the number of bytes you want to return.
GetChunk allows you to manipulate pieces of data, which conserves memory when working with fields larger than 64K.
If offset is 0, GetChunk begins copying from the first byte of the field.
If numbytes is larger than about 64K, an error occurs. After assigning the results of GetChunk to a string variable, you can use the Len function to determine the number of bytes returned. If numbytes is larger than the number of bytes in the field, only the actual number of bytes of data in the field are returned. If numbytes is negative, an error occurs.
In Microsoft Access, the Long Binary field data type is called an OLE Object field data type.