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

mccalla

New member
Local time
Yesterday, 19:57
Joined
Jan 23, 2008
Messages
6
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.

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

Thanks in advance,
mccalla

Remember, I am a newbie.
 
what version of Excel are you using, i remember Excel 97 used to have a limit of 255 characters per cell as i remember

oh and the squares are carriage returns, a new line entered into the memo
 
Hi,

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

Users who are viewing this thread

Back
Top Bottom