automating page setup

[sparx]

Is it possible to automate the page setup to make it "Legal" as Access seems to set a report to "Letter" as the default paper size.
This should be done using VBA coding, rather than having the user manually select File->Page Setup->Legal on every single report....

Any help would be greatly appreciated,

Thanks

Erik

 

[KevinM]

You shouldn't need to write any code to change the paper size(unless you do have reports that require different paper sizes).

Access defaults to whatever is set up in the Printer defaults in Control Panel.

Check this first to make sure it's set to 'Legal'.