Access 2003 Report forgets Page Size/type

I tried this during the opening of the form in which the PO is printed.  The data entry takes place on this form and then the print event is called from the form.

I figured if I opened and edited the report when this form was opened then it would preserve the settings for that user.

The papersize nor copies worked on this.

I also put this:

Reports("rptPO").Printer.PaperSize = acPRPSLegal
Reports("rptPO").Printer.Copies = 2

which yielded no results either.

any ideas on why this is not changing the settings?

DoCmd.OpenReport "rptPO", acViewDesign, , "PO_ID = " & Forms!frmPO!PO_ID, acHidden
    Reports("rptPO").Printer.PaperSize = acPRPSLegal
    Reports("rptPO").Printer.Copies = 2
DoCmd.Close acReport, "rptPO", acSaveYes

                                              

1:
2:
3:
4:

I have found that changing printer settings in design mode then saving the report or form often does not work.  You may need to set the printer settings each time you use the report or form.

Not all printers use consistent settings or use common printer driver specs. you mentioned the "po" printer uses a non standard paper size spec.  you sometimes have to play with the printer object settings to find what will work.

I have found the Sendkeys / RunCommand acCmdPageSetup technique to work in situations where the printer objects do not work.

What event should I change the print object settings in?  On Open, before open on calling form?

Any ideas on why I can't change the printer object settings?  My litmus test has been to change the print copies and the papersize.  However neither seem to stick.

Also, how can I specify what user created paper to use.  The constant is acPRPSUser (and I only have 1 custom paper) but will it automatically know to use that one?

<What event should I change the print object settings in?>
In the report open event.

<Any ideas on why I can't change the printer object settings? >
The printer object settings may not work with the "po" printer.

<Also, how can I specify what user created paper to use.>
Try creating a form with a textbox named txtPaperSize in a new database.  Try this code in its open event to see what you get:
For i = 0 to 256
    txtPaperSize = i
    Me.Printer.PaperSize = i
    DoCmd.PrintOut
    DoEvents
Next i

I tried the code and it says I can't do that event while the form is processing.

I still have not been able to edit the papersize or any other the printer properities.  However, I have been able to edit them manually.

<I tried the code and it says I can't do that event while the form is processing.>
 You mean the Do Events? Remove that line.

I get that error on the printout statement.

Create a command button on the form and add the code to its click event.