Blank pages in report

[TOPSie]

I am at my wit's end, so please treat me kindly and offer me some suggestions.
I have a very complex report which prints an Invoice (Report) and in some circumstances adds a Statement ( a sub report within the Invoice report).
The report is set to print on A5 paper. And by some magic it is set to double sided. Invoice on the front, Statement on the back

Last week it printed as expected, but following some issues with printers it now prints single sided.


If there is just an Invoice we get the Invoice and a blank sheet, If a statement is present we get Invoice, blank sheet, Statement (3 pieces of paper).

(If I manually create a 2 page Word document and set the print option to double sided then that's what I get - so the printer is still capable of doing double sided.

I have seen similar issues when certain elements of a report stretch outside of the paper size. But afaia the report design has not altered. I have even recreated the report by copying in the report from an old version of the code (predating this issue)

I don't know where to look next, so please offer me some suggestions.

[CJ_London]

perhaps it is to do with the default printer settings - in windows, go to printer and check the options

If there is just an Invoice we get the Invoice and a blank sheet

also check the printer settings for default paper size

[TOPSie]

I have tried everything I can with Printer Settings (from Windows). Just done it again on my test system (which has a different printer) - set every option I could find to double sided, but all comes out single sided. But at least this time there are no blank pages, so perhaps the report layout is correct and it does fit the page.
So still struggling - thanks for the suggestion.
My underlying problem is that I am not sure what the real issue is - so it is hard to describe it :-(

[davegri]

Don't know if it will help, but here's VBA to set printer to duplex for the indicated report (strDoc)

Application.Reports(strDoc).Printer.Duplex = acPRDPHorizontal 'acPRDPVertical for vertical flip

[TOPSie]

The (Invoice) Report is "printed" at over a dozen places in the code (I didn't write it, I inherited it). But at all these places in the code there is no "tweaking" of the Printer objects, just a simple

DoCmd.OpenReport "RepInvoice", acViewNormal, ,

with a single parameter of invoice number. So the code relies entirely on the Default printer settings in Windows (it uses the Default printer - not a named one).

[Welshgasman]

Print to PDF as a test and see how many pages.
Sounds to me like, your margins need to be decreased.