double side print

[iccsi]

DoCmd.OpenReport stDocName, acNormal I have above code to print my
report and always comes single side print even I set printer to double
side print from control panel printer setting.


ift only print double side when I use following preview and set print
setting from dialog.

DoCmd.OpenReport stDocName, acPreview

any information is great appreciated,

 

[Clifford Bass]

Hi,

After you print it manually, while it is still open, save it (File,
Save). That should save the duplex setting. Note that if you then change
the printer you are using, you may need to repeat the process.
Alternatively, you could try placing the following in the report's On Open
event:

Me.Printer.Duplex = acPRDPHorizontal

Clifford Bass