Calling the Page Setup PopUp from VBA..

[Brett Davis]

Hello..

I am using Access 2003 and I have a button on my form that I will have the
user click to bring up the Page Setup popup screen just like you would do if
you chose File -> Page Setup. Does anyone have the VBA code to accomplish
this?

Please advise...

Cheers!
Brett

 

[Daniel Pineault]

Try,

docmd.RunCommand acCmdPageSetup

Also, do not forget to trap error 2501 should the user cancel the operation.

 

[Brett Davis]

Thanks Daniel! When I put the code behind the button and I click on the
button, I get the following error message:
Run-Time error '2585':
This action can't be carried out while processing a form or report event.

How do I get around this?

Please advise..

Thanks,
Brett