Why does Access cut off data strings when exporting?

[Guest]

I have done a query in which I combined two text fields and when I try to
export the data to Excel or Word it cuts the data off at 255 characters. How
do I fix this?

 

[John Nurick]

Unfortunately this is how it works. When you export a query that
contains a calculated or formatted string, it is treated as a text field
and truncated at the 255-character text field limit.

As far as I know the work-rounds are
-export the two fields separately and combine them in the destination
application
-provide a temporary table with a memo field to receive the concatenated
text fields, and use the query to append records to the temporary table.
Then export the temp table.

 

[Guest]

I am trying to export an Access report to Word, and my memo field gets
truncated. I have no formatting or calculating on this field. Why would
this happen?

Jeff

 

[Guest]

Appendix to my previous post:

The text is not truncated at 255 characters, and do not seem to be truncated
at a standard length at all.