MS Access 2003 Report export to MS Word (.rtf)

[passterelli]

I have created a report that displays the contents of large memo fields. The report must be exported to MS Word (or .rtf) so the type style and type size can be modified according to the final user's preferences.

The report doesn't export as expected. When the exported .rtf file is opened in MS Word, the layout appears as it does on the report in MS Access. However, at the end of each line, there is a carriage return. Considering that each exported report may be 100+ pages, this makes type style and size manipulation very difficult.

Is there a workaround (either in Access or Word)?

[Megalog]

Depending on how your export ends up, you may want to try doing a find/replace for the carriage returns, and replacing them with nothing. Record the actions into a macro, clean up the code and turn it into a function you run after you do each export.

[DonRayner]

In Word, you should just be able to ckick on the show/hide icon on the standard toolbar. It looks like this ¶