Duplex Printing Issue

[NSAMSA]

Hi all:

I'm having an issue with a report I want to print double sided. I used the following vba on an a button:

Private Sub Command109_Click()

DoCmd.OpenReport "rptBFForm2side", acPreview

Reports("rptBFForm2side").Printer.Duplex = acPRDPHorizontal
End Sub

The issue is that the back sheet prints upside down, while my customer would prefer that the two sides have the same orientation. Is there a piece of code I could add in that would make the second side orient 180 degrees from its original position?

Regards

 

[JHB]

Have a look here, maybe it helps you, (I don't have any duplex printer, so I can't test it).
https://msdn.microsoft.com/en-us/li...inter.duplex.aspx?f=255&MSPPError=-2147217396

 

[NSAMSA]

Perfect... I figured there was an easy solution. Thank you!

 

[JHB]

You're welcome, good luck.