.RTF file Question

  • Thread starter Andre Laplume via AccessMonster.com
  • Start date
A

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

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

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

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"
 
R

Rick Brandt

Andre said:
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"
Click to expand...

"Snapshot Format" (including the quotes)
or
acFormatSNP
 
R

Rick Brandt

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

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