Open print options before priniting a report through VBA

in22

Registered User.
Local time
Yesterday, 20:25
Joined
Aug 16, 2013
Messages
38
Hi,

I am using command buttons on a report view. One each for:

Print Preview
Print Report
Exit Report

When I hit print report, access automatically sends it to the default printer and prints the entire report. However, I want to pop print options first (just like you get when you hit print icon in the print preview ribbon) in case someone only wants to print a specific page etc. and was wondering if there was a code for it? I would appreciate the help. Currently I am using the following for print report button:

DoCmd.PrintOut
 

Users who are viewing this thread

Back
Top Bottom