Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » Access report export to Word format lose image and border on the
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access report export to Word format lose image and border on the
Resolved · Urgent Priority · Version 2003
Reply
Access report export to Word format lose image and border on the
HiI have a few reports have been set up in the database, but when I export the reports onto Word, the images and border of tables are missing (not able to export), only left the text on the Word document with correct margin.
Could anyone help me? or VBA code?
Many thanks
For upcoming training course dates see: Pricing & availability
RE: Access report export to Word format lose image and border on
Hi Zhi,Thank you for your question.
As far as I am concerned there has always been a problem with images and border lines not transferring into the word document when you publish the Access report into word.
The reason behind this is the fact that it saves it as a Rich Text Format file extension(.rtf) instead of a word document extension(.doc). This is how Access has always behaved since earlier versions of the application.
One thing you could try is to PDF the report via the Print menu and use any pdf drivers you may have in the list and save it then as a PDF.
I hope this helps.
Regards
Simon
RE: Access report export to Word format lose image and border on
Hi Simon,Thank you for you reply. It is a solution to PDF the report
However, is there other solution such as VBA code to build the border itself other than PDF it?
As in office, not everyone's desktop has Adobe Acrobat (the writer version), So it is not possible to PDF document when they try to export the report.
So I am hoping to get other solution or VBA Codeto resolve the problem.
Many thanks
Zhi
RE: Access report export to Word format lose image and border on
Hi Zhi,Thank you for your response.
First take out all the existing borders.
To create borderlines you can create a long line of underscore (___) characters within a label instead of drawing a line and this will be exported to the word file.
I suggest you try and copy the picture into the resulting word document afterwards.
Unfortunately writing VBA code would be beyond the scope of the forum as it would take longer than the permitted time to answer forum posts.
I hope this answers your question.
Regards
Simon
Wed 3 Feb 2010: Automatically marked as resolved.
|
 |
|
» Forum post: Table Relationships |
Why do I have the same information repeated in my "courses" table? 
