Preventing extraneous line breaks when exporting report

[AliN]

I am making a report that includes, among other things, a text box that has
a memo field as its source. I have set the text box to "can grow," and when I
look at the report in print preview, it is wrapped correctly and looks fine.
The problem is that when I export the report to Word, there is a carriage
return (i.e. line break) after each row of text. I think it's a problem with
the formatting, not with how the data is stored, because when I copy the
contents of the memo field directly from the table and paste it into Word or
Notepad, it wraps like a normal paragraph. How can I get rid of the
extraneous carriage returns, so users don't have to delete each one to make a
normal paragraph?

I am currently using Access 2007, but we had the same problem in Access 2000
(my company just recently upgraded).

Please let me know if you need more information - I am new to this.

Thank you!

 

[Pete D.]

A report is for the printer so forced line feeds/carrage returns are normal
but not stored in the database as the report facility will add them as
needed. If they want to bring it into word, send it out as a
query/excel/CSV with out the formating of a report. Other than this you can
use the search/replace function in word to strip out the hard returns. Pete