Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Reports _ Formatting Issue Access Report To Pdf

Posted by: bunly11 Sep 9 2019, 12:31 PM

When I export my Access report at home the formatting is correct. However, recently when I export the report at work the formatting is off.
This recently started happening about 6 months or so. I would be able to preserve the formatting when I turned the wifi off but now the formatting is still off when I do this.
Does anyone know what the cause of this is or how I can fix it? Please see images.

Thank you.

Posted by: theDBguy Sep 9 2019, 12:47 PM

Hi. Welcome to UA! welcome2UA.gif

When you export a report to PDF, Access will use a printer driver to do it. Perhaps your PDF printer driver was changed somehow?

Posted by: bunly11 Sep 9 2019, 01:30 PM

Thank you - how would I check the print driver at home vs work?

Posted by: theDBguy Sep 9 2019, 01:50 PM

Try going to your Control Panel and to the List of Printers. Go to the Properties window of your PDF printer driver and see if you can find the version info there.

Posted by: bunly11 Sep 9 2019, 03:38 PM

I finally figured it out. I went to "Page Setup" and changed the printer from "Adobe PDF" to "Microsoft Print PDF".
Now the Report view and Print Preview match.
Thank you for your help!

Posted by: theDBguy Sep 9 2019, 04:01 PM

Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.