471,075 Members | 755 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,075 software developers and data experts.

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

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
2 3410
378 Expert 256MB
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
489 Expert 256MB
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.

Similar topics

reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.