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
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
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.
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.
