Call Page Setup Dialog Box From A Button On A Form

  • Thread starter Thread starter SQLSQUIRREL
  • Start date Start date
S

SQLSQUIRREL

Ok... for the love of cheese... somebody share with me how to call up the
Page Setup dialog box from a button on a form. I have tried this:
DoCmd.RunCommand acCmdPageSetup. This does not work... as it only works from
a menu bar. I am using Access 2003. Is there another way to call the Page
Setup dialog box from a button?

Please advise...

Thanks,
Brett
 
I assume you have the reprot already open in preview mode???

try:

DoCmd.SelectObject acReport, Screen.ActiveReport.Name
DoCmd.RunCommand acCmdPrint
 
Back
Top