Print ACCESS reports thru MS Word

[tjessejeff]

How do you send a report created in ACCESS to WORD to print as a document? Then I want to save it as a WORD Document.

 

[jiqjaq]

You can open Word via automation and create a normal word document. You can open Access via automation from Word and print a report.

You cannot print an Access report as a word document because it's not a document. MS has specifically made the Access report format proprietary to prevent anyone from creating the report via any other means other than the Access app itself. Both Access and Word use VBA but report objects are known only to Access.

 

[young]

Yes, you can. From report preview, export, select rtf format.

 

[bilby72]

Young yes that is true but how would you do that automated instead of selecting through all the menus and wizzards. You can also change the .rtf to .doc and it looks exactly the same as if you would see it as a printed report but you can edit the word doc.
#-)

 

[tjessejeff]

I am new at this. Thank you for your replies. I thought since they are both MS products that you can pass reports from ACCESS to print and save as a WORD document. Thanks for the help.

 

[GregGol]

We struggle with the same issue. RTF leaves several things to be desired in Word. For example, each line is a paragraph and usually starts with several blanks or a short-length tab. Also, the vertical spacing (before and after) is quirky and tries to emulate the happenstance of where the line was on the report. For example, the top line may have a Word "format - paragraph - space before" code of 50 pts. whereas the next line might have 6 pts. or zero. I have had some success at using Word macros to strip the offending codes and redo the pseudo RTF headers as Word headers. BUT, the macro is specific to each Access/RTF report and is worth doing only when you are reusing the same report format. We run 6-11 variations of the same report (the reported items differ) quarterly so it was worth my time.

 

[illini]

An Access report can be saved as a Word readable document via the .rtf format. Also, it would appear that you can edit this report once you open it in Word.

I use the following command to automate the process:

DoCmd.OutputTo acOutputReport, "Your_Access_Report", acFormatRTF, "C:\My Documents\Your_Report_Name.rtf", False

I have encountered problems with graphics (pictures & borders) though. The report I use has my company's logo. When I view or print the report from Access, the logo is visible. However, the .rtf document does not retain it.

Hope this helps. -illini

 

[tjessejeff]

Yes it does. I will try this and follow up with yu all. Again thank you for your help.