access output to word wrapping fields funny

[Devin]

I am trying to output a report from Access to MS Word (actually it is going
to an RTF which is then opened in word). For some reason, some of the fields
are truncating and the additional text from those fields is being displayed
on a single line at the top of the next page. The fields are set to allow
resizing, and the fields do wrap four or five lines, but it typically happens
when there is one or two words that don't fit on a line, so instead of
wrapping those words, they get pushed to the top of the next page.

Anyone else have these frustrations?
Thanks

 

[Tony Williams]

Have you checked the margins on the report are the same as in your Word
file?
Tony

 

[Larry Linson]

I am trying to output a report from Access to MS Word (actually it is going
to an RTF which is then opened in word). For some reason, some of the
fields
are truncating and the additional text from those fields is being
displayed
on a single line at the top of the next page. The fields are set to allow
resizing, and the fields do wrap four or five lines, but it typically
happens
when there is one or two words that don't fit on a line, so instead of
wrapping those words, they get pushed to the top of the next page.

Yes, many do... the translation to RTF seems to "leave something to be
desired" in accurately reproducing the Access Report's formatting. One
alternative is to download the Snapshot Reader for the user's and saving as
a Snapshot, then giving the users that file. I've had better luck with HTML
than with "save to Word" RTF in getting the formatting I want, but YMMV.

Larry Linson
Microsoft Access MVP

 

[Devin]

Larry, thanks for the response. I have too many people, and the list is
fairly dynamic. I saw a forum that mentioned a way to take as a snapshot,
and then convert to rtf that fixed the problem. But, I have not been able to
find that tool / macro. Any other ideas?

Thanks

 

[Larry Linson]

"Devin" wrote

Larry, thanks for the response. I have too many people, and the list is
fairly dynamic. I saw a forum that mentioned a way to take as a snapshot,
and then convert to rtf that fixed the problem. But, I have not been able to
find that tool / macro. Any other ideas?

You will find that tool at MVP Stephen Lebans' site, http://www.lebans.com.

Or you could google here and the USENET newsgroup comp.databases.ms-access
to find some recommendations on less-expensive alternatives (some free) to
Adobe Acrobat for printing to PDF directly. I use an old copy of Acrobat
that still does everything I need for Access Reports.

Larry Linson
Microsoft Access MVP