Exporting Report to Word

A

AmyK

I have a user who wants to manually edit text from an
Access Report (mostly to add bullets, etc) I use the Word
Link or the Export to RTF option, but either way, once the
RTF is opened in Word - some data is randomly cut off.
Any suggestions to how I can get this report in Word?
Thanks.
 
L

Larry Linson

AmyK said:
I have a user who wants to manually edit text from an
Access Report (mostly to add bullets, etc) I use the Word
Link or the Export to RTF option, but either way, once the
RTF is opened in Word - some data is randomly cut off.
Any suggestions to how I can get this report in Word?
Click to expand...

You can use the mail merge feature, or open the Access database from word...
but neither will get you the formatted report into Word.

It can be problematical to get a report adjusted so that all looks well when
it is translated to RTF. If you look at the formatted output once you get it
in word, I think you'll be unpleasantly surprised. In fact, HTML may turn
out to be a better "intermediary", but you are likely to still have to do
some tweaking of your report design.

Recent versions can export to and import from XML, but, alas I have not done
that to comment on details. Perhaps someone who has will see this and add
their comments.

Larry Linson
Microsoft Access MVP
 
E

ES

From my limited experience the cut offs seem to be caused
by the margins of the text box combined with differences
in the specifics of how Word and Access size fonts. They
especially seem to happen when you use the CanGrow
property on a text box to automatically size it in
response to the amount of text in the field in each record.

The only solution I have found is to increase the Bottom
Margin and Left Margin properties of the text box in
Access before you export. The default is 0. I found
using 0.199cm was adequate to solve the problem.

Cheers
 
Top