.RTF file Question

[Andre Laplume via AccessMonster.com]

We have started to Export MsAccess Reports as .rtf files to a share as
opposed to printing everything. A user has noticed, and I verified that
when I Open MsWord to view a given .rtf file, it appears as though the line
spacing is off. In other words, if I preview / print the report in
MsAccess, I may get 60 (made up) lines per page and my footer is always an
inch from the bottom. The same report, exported as a .rtf doc and opened
in MsWord will still have the 60 lines but they are closer together and I
may have a 3 inch margin at the bottom of the page.


Any ideas?

 

[Rick Brandt]

We have started to Export MsAccess Reports as .rtf files to a share as
opposed to printing everything. A user has noticed, and I verified
that when I Open MsWord to view a given .rtf file, it appears as
though the line spacing is off. In other words, if I preview / print
the report in MsAccess, I may get 60 (made up) lines per page and my
footer is always an inch from the bottom. The same report, exported
as a .rtf doc and opened in MsWord will still have the 60 lines but
they are closer together and I may have a 3 inch margin at the bottom
of the page.


Any ideas?

Export to RTF is unreliable and has always been that way. You have just
found the least offensive of the many problems that exist with it. Have you
looked at the Snapshot Format instead? Much better and you get to keep your
graphical elements as well.

 

[Andre Laplume via AccessMonster.com]

Just tried it and it appears to work better....Is the snapshot view
something everyone who runs windows would have....?

 

[Andre Laplume via AccessMonster.com]

Just tried it and it appears to work better....Is the snapshot view
something everyone who runs windows would have....?

 

[Andre Laplume via AccessMonster.com]

How would I specify a .snp file in my VBA Output...for a .'rtf' file I do
something like this:

DoCmd.OutputTo acOutputReport, "MasterDeptListingReport", "Rich Text
Format", "X:\......\filename.rtf"

 

[LGC]

Another option you might consider is converting the report to pdf format.

LGC

 

[Rick Brandt]

How would I specify a .snp file in my VBA Output...for a .'rtf' file
I do something like this:

DoCmd.OutputTo acOutputReport, "MasterDeptListingReport", "Rich Text
Format", "X:\......\filename.rtf"

"Snapshot Format" (including the quotes)
or
acFormatSNP

 

[Rick Brandt]

Just tried it and it appears to work better....Is the snapshot view
something everyone who runs windows would have....?

It is on the Office CDs but is likely not installed by default. It is also a
free download from Microsoft's web site.

 

[Andre Laplume via AccessMonster.com]

THANK YOU ALL!