newbie46
asked on
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?
If you specify a .doc file that should be sufficient.
Please post the code you are using now.
ASKER
matthewspatrick,
DoCmd.OutputTo acOutputReport, "rptA", acFormatRTF, PMTableName & ".rtf", True
DoCmd.OutputTo acOutputReport, "rptA", acFormatRTF, PMTableName & ".rtf", True
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
thanks.
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.
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.