DAO problem with Memo fields > 255 char 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

 

[John Nurick]

Hi Peter,

I have no problem doing this with a DAO recordset with a memo field
containing thousands of characters.

There are, however, issues if Access is applying formatting to the memo
field or if the source of the recordset is a query in which the contents
of the memo field are modified in some way. For details, search for
access memo truncated
in the Microsoft knowledgebase at
http://support.microsoft.com/search/default.aspx