Report Footer

[Mei Qin]

Hello,

I use the following code to export my report to RTF format
report, so the user can open it in word.

DoCmd.OutputTo acOutputReport, "rptAll",
acFormatRTF, "Report.rtf", False

I put the page footer on report in access. But when I
open the report in word, the footer appears at the
different place on each page. Some page has a samll
margin, some page has a big margin. How can I control
this, so the page footer will be at the same place for
each page.

Thanks for any help!

Mei

 

[Larry Linson]

Translating Access reports accurately to RTF has always, in my experience,
been one of the "rough spots". It has long been on many users' wish lists...
find a wish list on the Microsoft site and add your request. If they hear it
enough, from enough users, they will pay attention.

I have had better luck, in recent years, with exporting to HTML but that
doesn't render exactly, either.

But if your doing so is simply to expedite viewing of the report by those
who do not have Access, the reports render quite accurately when printed to
a .PDF (you'll need some version of Adobe Acrobat, but a several-versions
out-of-date copy still serves my needs quite well -- the viewer is free, but
Acrobat itself is not) or to an Access report "Snapshot" format.

In either of these cases, the user will need a viewer -- but almost
everybody has an Acrobat viewer, and the Access snapshot viewer is a free
download from Microsoft.

If you need to further manipulate the report with Word, I don't have a good,
easy suggestion... mail merge for a whole report could be complex, as could
controlling Word with OLE/COM automation to create an entire report.

Larry Linson
Microsoft Access MVP