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

[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.

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

Thanks in advance,
mccalla

Remember, I am a newbie.

 

[Darth Vodka]

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

 

[mccalla]

Hi,

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