Why does Access cut off data strings when exporting?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
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
 
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.
 
Back
Top