.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?

 

[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!