Truncation when exporting to excel

  • Thread starter Thread starter Liz Simmonds
  • Start date Start date
L

Liz Simmonds

I have a memo field which is part of a report Im exporting
to Excel and it keeps getting truncated. Is there any way
around this?

Thanks
Liz
 
How are you exporting? Via File | Export process? That process uses "old"
EXCEL specs that will truncate long (greater than 255 characters) strings.

Use a macro and do the TransferSpreadsheet action. Select the EXCEL version
of 97 or higher version as the argument for file version.

Or use VBA code and use DoCmd.TransferSpreadsheet in similar way.
 
Back
Top