[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • Last Modified:

Can Access 2007 export a report to Word and save it in a 'prior to 2007' format?

I have a command button on an Access 2007 form which exports a report to Word. Is it possible, through VBA, to export the report and have it saved in a format compatible with older versions of Word?
0
newbie46
Asked:
newbie46
1 Solution
 
peter57rCommented:
If you specify a .doc file that should be sufficient.
0
 
Patrick MatthewsCommented:
Please post the code you are using now.
0
 
newbie46Author Commented:
matthewspatrick,
DoCmd.OutputTo acOutputReport, "rptA", acFormatRTF, PMTableName & ".rtf", True
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
Patrick MatthewsCommented:
Access does not do a native export to Word.  The closest it gets to is RTF (rich text format), which Word is able to interpret.  Some, but by no means all, of the formatting in Access is translatable into RTF, but in my experience the fidelity is not high, and I avoid using it unless I absolutely must.

Have you tried opening an RTF document generated from Access 2007 in Word 2003?  My gut feeling is that it will probably work.
0
 
newbie46Author Commented:
thanks.
0
 
Dale FyeCommented:
Personally, I avoid the RTF export as well, since it embeds hard carrage returns and has other formatting issues.

If I want my output to go to Word, I generally write a custom procedure that opens Word via automation, and I build the Word document from scratch.  I could post some sample code (if you are interested), it wouldn't mean much because all the tables and fields are meaningless, but it might give you some ideas regarding how to do this.
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now