Make report open to "Legal Paper" 8.5/14

[brian0721]

Is there a way to make it always open to legal paper. I have changed it in page setup, unchecked the autofix button or whatever it is. But access 2k bug is killing me. There has to be a way to make this work!

Any help? A Macro maybe?

 

[Kodo]

try putting this in the reports on_open event.

Me.Printer.PaperSize = acPRPSLegal

 

[brian0721]

try putting this in the reports on_open event.

Me.Printer.PaperSize = acPRPSLegal

It doesn't like the .printer part Any other idea?

 

[RichO]

How about in design view, go into File > Page Setup and change the paper size there. Then save the report.

 

[brian0721]

I've done that a thousand time. Works fine on my PC, but when other users from other PC's open the report, it opens up Letter size. Pretty sure its an A2K bug, but was hoping that there was a way to get around it...

??????

 

[RichO]

Maybe your problem is related to this bug...

http://www.access-programmers.co.uk/forums/showthread.php?t=62011

Try installing the fix on one of the other machines and see if it does the trick.