98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Access report export to Word format lose image and border on the
Access report export to Word format lose image and border on the
Resolved · Urgent Priority · Version 2003
Fri 22 Jan 2010, 15:08Delegate Zhi said...
Zhi has attended:
Access Intermediate course
Access Advanced course
Access report export to Word format lose image and border on the
Hi
I 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
Wed 27 Jan 2010, 13:49Trainer Simon said...
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
Wed 27 Jan 2010, 14:41Delegate Zhi said...
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
Wed 27 Jan 2010, 17:05Trainer Simon said...
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
Mon 9 Nov 2015, 12:18Mike (guest) said...
RE: Access report export to Word format lose image and border on
I find a free online pdf to word converter to <a href="http://www.online-code.net/pdf-to-word.html">convert pdf to word online</a>. all the content and image will retain the original formatting and location in the converted word document.
Mon 9 Nov 2015, 12:21Mike (guest) said...
RE: Access report export to Word format lose image and border on
I find a free online pdf to word converter to convert pdf to word online. all the content and image will retain the original formatting and location in the converted word document.
Wed 3 Feb 2010: Automatically marked as resolved.
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. |
