Button on Report (1 Viewer)

[LNewton]

Is there a way to put a functioning button on a report. Have a rpt that is at times more than one page and I want to duplex print at that time. They also want to preview the report prior to printing and do not want to minimize the report to click the duplex button. Any ideas?

 

[Fornatian]

I achieved this by creating a custom menu bar with a function call which printed the report a number of times:

Public Function PrintTwice()
DoCmd.PrintOut acPrintAll, , , , 2
End Function

Set the OnAction event of the Command bar button (in the buttons Properties) to

=PrintTwice()