Export Conditional Formatting to Word Document

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created different conditional formats using Case statements in the
OnFormat detail event of my report. All works OK.
I now want to export my report to a word document, but the conditional
formats do not go across. The reason for using Word is so that I can email
the report to my customer who then in turn wants to be able to add his own
comments before passing it onto his customer.

Thanks
 
Passing a report to Word does not preserve the formatting.

You can send it as an MS Snapshot format, but that will not be updateable.

You can also send it as a PDF file if you have a pdf writer such as
cutepdf.exe.
 
I have used both of these formats, but the report does need to be updateable
and pdf can only be updated if the customer has software to do it, which is
this case he does not.
Thanks
Sue
 
I understand that, but the fact still remains that RTF format is not DOC
format. Much of the formatting will be lost.
 
Sue,

Create a Word template to hold the contents of your Access report. Write
automation code that opens a copy of the template, exports the report
contents to the template copy and formats the template copy with the same
formating that you do in conditional formating in Access.
 
Back
Top