Re: [MSAccessProfessionals] Print preview doesn't match actual print

I second Duane's advice. If the PDF is properly structured then print that.

 

You might want to double-check the margins. If there is a control forcing the right margin to expand it might be causing blank pages to print.

 

Regards,

Bill Mosca

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Wednesday, July 27, 2022 3:47 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Print preview doesn't match actual print

 

Hi Jane,

I would print to pdf first and then print the pdf. If the pdf is always correct than it might be the printer driver. I haven't heard of an issue like this that didn't involve the data source but 150 pages is a lot. 

 

Duane

Sent from my mobile

On Jul 27, 2022, at 5:25 AM, Jane <jcross@crossproducts.plus.com> wrote:

Hi all
I have an Access report (invoice) which displays as either 1 or 2 pages in print preview. If the user then goes to print it, it intermittently tries to print many pages (commonly 150+ before they cancel the print).
The report has a subreport at the top of each page which displays the company name/logo/ address etc. This subreport is used in other reports & no other reports have any printing problems.
If the user lets it prints, then it prints the first 1 or 2 pages correctly, but the remaining pages (before unplugging the printer) only print the contents of the subreport.
The report has been printing correctly for many years, but this issue is increasing in frequency. 

Is this more likely to be a problem with the print driver or the Access report (size maybe)?