Call Page Setup Dialog Box From A Button On A Form

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
 
A

Albert D. Kallal

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

try:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Page setup" dialog 1
Calling the Page Setup PopUp from VBA.. 2
Dialog box stays on top of form 2
Enter Parmeter Dialog Box 1
Hiding a dialog form 4
Question about Dialog form 3
Why doesn't this work!!!... 1
Can't use the Page setup dialog box in Outlook 2007 1

Top