Using VBA to change page setup

[Guest]

In Reports - File - Page Seup - Page tab there is a combo box named "size"
where you can select different envelopes.

Can this value be changed using VBA and a combo box on an Access 2003 form?

 

[Arvin Meyer [MVP]]

Yes, look up "PrtDevMode" (without the quotes) in the Access help files.
Paper size is one of the attributes that can be changed. There is a table of
values which you can use in a combo box on your form.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

In Reports - File - Page Seup - Page tab there is a combo box named "size"
where you can select different envelopes.

Can this value be changed using VBA and a combo box on an Access 2003

form?