.RTF file Question

  • Thread starter Thread starter Andre Laplume via AccessMonster.com
  • Start date 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?
 
Andre said:
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?
Click to expand...

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.
 
Just tried it and it appears to work better....Is the snapshot view
something everyone who runs windows would have....?
 
Just tried it and it appears to work better....Is the snapshot view
something everyone who runs windows would have....?
 
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"
 
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
 
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.
 
Back
Top