Call Page Setup Dialog Box From A Button On A Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SQLSQUIRREL - 28 May 2008 01:37 GMT

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

Reply to this Message

Albert D. Kallal - 28 May 2008 10:00 GMT

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

try:

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

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Reply to this Message