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

The UK's most regular instructor-led training courses.
Training information: advanced micorosoft access training · Access training · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Urgent Priority · Version 2003

2 posts

ReplyFri 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

Version	Date	Location	Places available	Book	Next place rate (£)		List price
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice	List price
2010	Fri 17 Sep 2010	Bloomsbury	9		£275	£280	£299
2003	Fri 1 Oct 2010	Bloomsbury	8		£223	£228	£245
2003	Mon 8 Nov 2010	Southwark	8		£218	£223	£245
2010	Thu 25 Nov 2010	Bloomsbury	8		£225	£230	£299
2007	Fri 26 Nov 2010	Bloomsbury	6		£229	£234	£245
2003	Tue 14 Dec 2010	Southwark	10		£142	£147	£245
Full Schedule: See all 22 Access Advanced course dates. Bookings currently available until 30th September 2011.

726 posts

ReplyWed 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

2 posts

ReplyWed 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

726 posts

ReplyWed 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

Wed 3 Feb 2010: Automatically marked as resolved.

· Getting To The Nitty-gritty Via Microsoft Access
· Discover Decisive Details In Your Data, With Access 2010
· Access And Its Uses On The Web
· A Quick Intro On How Access Uses SQL
· Why consider Access Visual Basic training?

Please browse our web site to find out more about
advanced micorosoft access training and other Microsoft training courses.

Access tip:

Design View in Relationship window

Your in the Relationship window and changes are required to be made to a Table's design.

Rather than exiting the Relationship window, if you perform a right-mouse click on the table, it opens that table up in Design view

View all Access hints and tips