exporting report in RTF, losing formatting...PLEASE help if you ca

[ac512]

Hello
Within my access database (2002 version) I have a number of reports which I
need to send to individuals outiside the company I work for. Unfortunately
they do not all have Microsoft Access, and as a result, I have been forced to
export the reports in Rich Text Format (RTF) before sending them. When I
export the reports, I actually lose some of the formatting, as well as any
pictures/images contained within the reports.
I would be most appreciative of any suggestions/ideas which may enable me to
retain the images when I export the reports, even if it involves sending them
in a different format (but I would like to retain as much as the report
formatting as possible).
Many thanks in advance

AC

 

[Wayne Morgan]

You're correct, RTF doesn't fully support the formatting in an Access
report. If you need a format that will, try exporting the report as a
Snapshot file. The recipients can view this file using the free Access
Snapshot Viewer available here:

http://www.microsoft.com/downloads/...3f-6d74-423d-8274-8b7e6313edfb&DisplayLang=en

 

[ac512]

Thanks very much for your prompt and helpful resonse Wayne.
Very much appreciated
AC

 

['69 Camaro]

Hi.

I have been forced to
export the reports in Rich Text Format (RTF) before sending them. When I
export the reports, I actually lose some of the formatting, as well as any
pictures/images contained within the reports.

I'd recommend the Snapshot Viewer, as well, but another popular alternative
is exporting to PDF format, which retains the report's formatting. To export
to PDF format, make your PDF program, such as Acrobat Writer, the default
printer and "print" the report with the following line of code:

DoCmd.OpenReport "rptMyReport", acViewNormal

If you are using Access 2002 or higher, then you can use code to switch the
default printers. If you are using an earlier version, check out Albert
Kallal's switch printer code on the following Web page:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

If you don't already have Acrobat Writer installed, you could install a free
one, such as CutePDF, and print the report to it. Please see the following
Web page:

http://www.cutepdf.com/Products/CutePDF/writer.asp

It requries Ghost Writer (link found on that same Web page) and the printer
driver.

Other PDF writers to consider:

http://www.pdf995.com
http://www.primopdf.com
http://sourceforge.net/projects/pdfcreator

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.

 

[ac512]

Thanks very much...also very helpful!
AC

Hi.


I'd recommend the Snapshot Viewer, as well, but another popular alternative
is exporting to PDF format, which retains the report's formatting. To export
to PDF format, make your PDF program, such as Acrobat Writer, the default
printer and "print" the report with the following line of code:

DoCmd.OpenReport "rptMyReport", acViewNormal

If you are using Access 2002 or higher, then you can use code to switch the
default printers. If you are using an earlier version, check out Albert
Kallal's switch printer code on the following Web page:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

If you don't already have Acrobat Writer installed, you could install a free
one, such as CutePDF, and print the report to it. Please see the following
Web page:

http://www.cutepdf.com/Products/CutePDF/writer.asp

It requries Ghost Writer (link found on that same Web page) and the printer
driver.

Other PDF writers to consider:

http://www.pdf995.com
http://www.primopdf.com
http://sourceforge.net/projects/pdfcreator

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.