Export Report

[Blacknife]

I need to convert a report to word or some other format but whenever i do it loses formating like lines, ect. Is their anything I can do about this?

 

[edtab]

You will always lose some elements of your report if you export it using Access. What you need to do is convert it to PDF format by printing it
to a PDF writer such as Adobe Distiller. There are also some shareware PDF writers available for free if you search the internet.

Another way (more difficult) is to use VBA code to convert your report from Access to PDF.

 

[Blacknife]

Thanks

Great Idea. I grabbed a shareware writer that worked perfectly. Thanks alot.

 

[edtab]

I'm glad to hear.

 

[ckitzman]

Same prob - What did you use

Great Idea. I grabbed a shareware writer that worked perfectly. Thanks alot.

What tool did you find/use?

 

[edtab]

Try downloading CutePDF. Here's a link you can use:

http://www.download.com/CutePDF-Printer/3000-6675_4-10206470.html

 

[Keith Nichols]

Blacknife,

I see your problem is solved, but thought I would chime in anyway with a couple of alternatives.

If the people getting the report have Access on their PC then you can use the built in snapshot report format. This is exactly as formatted on your system but is uneditable. The only advantages I can see of PDF is that none Access users are likely to have a reader and there is a limited ability to select text.

There is a utility on Steve Leban's website http://www.lebans.com/ReportUtilities.htm
that will

Export to MS Word. Output exact duplicate of a Report to RTF, including formatting and all graphics. This file can be loaded into MS Word for limited further editing or inclusion into a larger document.

I had a look at this once a long while ago and decided not to use it so I can't really say how well it works, but if you need editability (allow users to cut and paste from the report for instance) and your formatting, then this may be the thing for you.

Hope this was of interest