How do I set page size from a button on a form?

[Gary Hull]

I have a form that has two buttons the first one prints and 8 ½” x 11”
report the other prints an 11”x 14” report. Right now I am using two
reports, what I would like to do is to use one report and have the code on
the buttons to set the page size.


Thanks
Gary

 

[Allen Browne]

If you are using Access 2002 or 2003, you set the PaperSize property of the
Printer object, e.g.:
Application.Printer.PaperSize = acPRPS10x14
However, changing this setting does not adapt the Width of the report to the
available width (paper width less left and right margins.) You may find it
easier to save 2 reports, and call up the relevant one.

If you are working in an older version of Access it is messier still. This
will give you a lead:
http://www.mvps.org/access/reports/rpt0009.htm