DAO recordset on memo type field >255 long

[Peter Dave]

Hi

I have a table with a memo field with data frequently >
255 characters.

My ultimate goal is to copy data from that table into a
word document table.

The method I am using is to query the table using a DAO
recordset and then I loop through the record in the record
set and insert them in my word table using vba code.

When the data is > 255 characters long, the characters
after 255 are not displayed properly in the recordset and
therefore in the word document.

Any idea what can be done about this? Maybe a different
method for accessing the data?

Thanks