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