Printing an open report and turning off the "2 sided" option.

[kdbailey]

I am trying to create a button on a report that prints out the report. The default option for 2 sided printing is true on all computers at the office. I am looking for the command how to do this, whether I have to find each computer's default printer options or what.

Anybody have an idea how to adjust this besides going into printer settings and changing the defaults manually.

Access 2007

[ranman256]

In the macro or code that prints the reports
Run a function that sets the DUPLEX setting:

   'acPRDPSimplex = 1
   'acPRDPHorizontal =  2
   'acPRDPVertical = 3

   Select Case s
    Case "": 'nothing to do
    Case "1": rpt.Printer.Duplex = acPRDPSimplex
    Case "2": rpt.Printer.Duplex = acPRDPHorizontal
    Case "3": rpt.Printer.Duplex = acPRDPVertical
   End Select

[kdbailey]

I need some clarification by what you mean with the DUPLEX setting.

How do I lead into the code you provided? What is "s"?

[ranman256]

If you are using code on the button CLICK event,
set the duplex mode before printing

  ''just set:
Printer.Duplex = 1    'non duplex mode
  ''then
docmd.openreport  rptMyReport