GetChunk Method


Returns all or a portion of the contents of a Memo or Long Binary Field object in the Fields collection of a Recordset object.


Set variable = recordset ! field.GetChunk (offset, numbytes)

The GetChunk method syntax has these parts.




A Variant (String subtype) that receives the data from the Field object named by field.


An object variable that represents the Recordset object containing the Fields collection.


An object variable that represents a Field object whose Type property is set to dbMemo (Memo) or dbLongBinary (Long Binary).


A Long value equal to the number of bytes to skip before copying begins.


A Long value equal to the number of bytes you want to return.



The bytes returned by GetChunk are assigned to variable. Use GetChunk to return a portion of the total data value at a time. You can use the AppendChunk method to reassemble the pieces.

If offset is 0, GetChunk begins copying from the first byte of the field.

If numbytes is greater than the number of bytes in the field, GetChunk returns the actual number of remaining bytes in the field.

Caution Use a Memo field for text, and put binary data only in Long Binary fields. Doing otherwise will cause undesirable results.