Avatar of Linda Quintana
Linda Quintana
Flag for United States of America

asked on 

Access 2013, how do I 'export' a report to EXCEL without the 'long text' field getting trucated at 255 characters?

I have been searching the 'WWW' over trying to find out how to fix a problem with exporting a query or report in Access 2013 to Excel without truncating data.   I have a 'long text' field that truncates to 255 characters when the data is exported to Excel.  Frustrating and surprising this happens.
Sadly, many of the report users require the format to be in Excel -- otherwise a PDF version looks terrific.

I need to be able to export the query or report without loosing the characters in the 'long text' field.  Any ideas on how to fix this frustrating problem?

Thank you  - lq
Microsoft AccessVBA

Avatar of undefined
Last Comment
Linda Quintana

8/22/2022 - Mon