How to export a report?

[tom]

Is there any good way to export a report?

I have tried to export a fairly complex report using HTML and word, but the
formatting is all messed up. How do I
go about exporting and getting the formatting correct?

 

[Rob Parker]

For anything other than a very basic text report, there are only two options
which will retain all formatting, including any graphical elements (even
such basic things as lines and borders/boxes. They are:
Snapshot format - you need to export the report via the DoCmd.SendObject
command, and select acFormatSNP as the output format, or
pdf format - you need to install a pdf generator as a virtual printer,
and print your report via that. There are several free pdf generators; one
that is often recommended in these newsgroups is Stephen Lebans, at
http://www.lebans.com/reporttopdf.htm

HTH,

Rob

 

[Rob Parker]

Oops, forgot the other way of generating a snapshot report - DoCmd.OutputTo
(with acFormatSNP as the output format).

Rob