formatting of a memo field

[vid]

Hi!

When I export a report based on the a query with a memo field in it, the formatting in that field is not carried forward to excel. Meaning that if someone has pressed "clt+enter" and the memo field has text in two lines, it appears as one in the excel file. I have to then double click on each cell separately to get the proper format. Is there anyway to automate this?

Thanks in advance

 

[madEG]

Never tried this before, but perhaps you have some luck trying to replace the CR/LF's with char(10) and/or char(13) when sending to excel...

e.g. http://www.officearticles.com/excel/carriage_return_within_a_cell_in_microsoft_excel.htm

as like the bottom example...

Just a thought.