Report Export to Excel Memo field truncates (512 chars).

M

mccalla

Hi,

I am very new to MS Access. I have inherited an existing app which was done
in MS Access 2003. In this app, there is a report which contains a memo
field. There are no formats, functions, unions, or anything. It is populated
from a simple select. The problem is....when the user exports the report to
excel, it seems to be truncating this memo field after 512 chars. After that,
there appears funny chars that look like tiny squares.

Excel is 2000. When I do save, I save file using Microsoft Excel 97-2003(xls).

I need to get this solved ASAP. Any solution would be appreciated.

Thanks in advance,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Memo Field is truncating to 255 Chars 6
conditional format truncates memo field 1
text box in report is truncating memo field at 255 characters 2
memo field expansion in details section of report? 1
Memo field truncating in report 3
Access Report with Sub-Report & memo field ??? 4
Export to RTF/HTML corrupts report 3
Place a memo field after sub report 0

Top