Access report export to Word format lose image and border on the

Resolved · Urgent Priority · Version 2003

Fri 22 Jan 2010, 15:08 Delegate 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:49 Trainer 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:41 Delegate 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:05 Trainer 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:18 Mike (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:21 Mike (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 courses