Output report to MS Word

[Access Virgin]

I have used DoCmd.OutputTo acOutputReport, stDocName, acFormatRTF, "Template.doc", True to output a report to MS Word but it doesnt carry across the look of my Access report. I had labels coloured grey with darker grey borders etc. Is this possible or is it only possible to copy across text?

 

[Hayley Baxter]

Snapshot format keeps the layout of the report as it is in access but taking this to word doesn't take all the formatting of the report.

I found a sample upon searching the net that keeps the format of the report and takes this accross to word. The link is in this thread if you want to have a look but it requires a fair bit of coding. You may be able to change this to suit your requirements.

Alternatively you can try using PDF Format.

Hay