Print command button that allows user to select print options

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create either a command button of macro that when clicked will
send a report to the print dialog window so that the user can select a
printer and change options as needed. I am not very familiar with Access and
have tried using the command button wizard, but it simply sends the report to
the printer.

Is there a simply script or macro that will let me print a report similar to
going to File/Print from a switchboard button?
 
1. In your macro, use the OpenReport action.
In the lower pane of the macro design window, set View to:
Print Preview

2. In the 2nd row of your macro, choose the RunCommand action.
In the lower pane, the Command to:
Print

Alternative approachs:
- If you always want to send the report to the same printer, you can open
the report in design view, choose Page Setup from the File menu, and on the
Page tab, tell it to Use Specific Printer.

- In Access 2002 and later, you can set the Printer object before you
OpenReport.
 
Back
Top