By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,663 Members | 1,827 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,663 IT Pros & Developers. It's quick & easy.

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

P: 1
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)?
May 15 '09 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 378
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.
May 15 '09 #2

Expert 100+
P: 489
In Word, you should just be able to ckick on the show/hide icon on the standard toolbar. It looks like this
May 16 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.