Problem with exporting reports in MS WORD

[kram327]

I have an access program, for me it's all okay to what my boss' preference but the problem is he want's it to be exported in MS WORD.

I have two questions regarding ACCESS Reports:

1. How can i export the whole contents of the Report to Microsoft WORD (including all the formats (e.g. lines, background color of the text boxes) i've made)?
Also in that report I have included a memo field where the height of it depends to how long the data is, it automatically grows whenever there is a long data in it. The problem is everytime it extends its height, the format has been changing. I mean that the other text boxes should also extend its height whenever memo field is extending.

2. What can i do so that the height of all the text boxes and memo field will synchronize during run-time?

I hope you can all help me.

 

[jrbarnett]

Hello Kram327

With answers to your questions:
1) Exporting to Word (RTF format) will not preserve all formatting, and there is no way of doing this while keeping it in Word format. Options are as follows:
a) Use the Snapshot format, included in all versions of Access since 97 SR-1, which is similar in idea to PDF.
The Snapshot viewer which can be used for viewing and printing is a free program on the Office CD.

b) Export to PDF format, and then any computer with Adobe Reader installed can view it. You need not spend money on the Adobe or third party PDF writing software; a free method of creating PDF's is available using Ghostscript and GSView32 software from

http://www.ghostscript.com

2) Have you considered using the "Can Grow" and "Can Shrink" properties on boxes and controls within the appropriate section, plus the section itself to allow it to expand and contract.

John

 

[cghoga]

I second that.

Or if you had Crystal Reports you could build the reports in Crystal.

Regarding the memo field, you could set the height of the other fields to match the height of the memo field when the code executes.

Me.Field1.Height = Me.YourMemoField.Height
Me.Field2.Height = Me.YourMemoField.Height
Me.Field2.Height = Me.YourMemoField.Height

 

[kram327]

Hi jrbnett

I'm confused with

http://www.ghostscript.com,

i don't know how to use it well. I have downloaded a file but i don't know how to use it as well. Can you exactly tell me what software i need to download and what application i need to use?

Hi cghoga

I don't have cystal reports, can it be possible to do that codes in MS ACCESS alone?

regards,

Mark

 

[jrbarnett]

Mark

1. Download Ghostscript and GSView32 from the site and install both.
2. Install a Postscript printer driver on your Windows system on port FILE:. It doesn't matter which one, and you don't need to own that particular type of printer at all.
3. Print the report to the postscript printer, and when prompted, enter a path and filename. This will create a .EPS file on disk which is an image of that report.
4. Load GSView32 and open the output file created in step 3.
5. Click File -> Convert. Choose the PDFWrite driver, click OK and enter a path and filename. Be sure to use a .PDF extension.
6. Test the resulting file in Adobe Acrobat reader.

John