Open Page setup for report (1 Viewer)

[theinviter]

Dears:

I have a Form for label printing, each location has a different printer, so i want to make A button on the form, then after clicking, it will open Pahe setup for the label where user can select the printer and edit margin.
is there any way to open page setup directly through a button from a form.

 

[arnelgp]

you need to open the report in preview
then issue:

docmd.RunCommand acCmdPrint

this will show the "printer" setup.

 

[theinviter]

thanks But i need to show page setup where user can Edite the Margine once and not do it every time.

you need to open the report in preview
then issue:

docmd.RunCommand acCmdPrint

this will show the "printer" setup.

 

[arnelgp]

Margine once and not do it every time.

then it is not Possible, you need to open the Report in Design view and set it up there (once not everytime).

 

[theinviter]

then it is not Possible, you need to open the Report in Design view and set it up there (once not everytime).

yes , but the ribbon disabled for user, but i want once to open the report in design view, show page setup.

 

[theinviter]

yes , but the ribbon disabled for user, but i want once to open the report in design view, show page setup.

Done below code,

DoCmd.OpenReport "Items", acViewPreview, , "[ID] = " & Me.ID, acWindowNormal
DoCmd.RunCommand acCmdPageSetup

but getting a message to enter parameter value = ListID .

how to correct this.