Error in changing printer properties

E

eddiedressler

To all,

I have run into the strangest thing in Access 2002, I hope someone has
seen a work around.

I am using the Printer object to change the Orientation and PaperSize
properties. I can change to properties successfully with VBA, however
the changes are not displayed on screen. I am runing the code on the
open event of the report...

Reports("reportName").Printer.Orientation=acPRORLandscape
Reports("reportName").Printer.PaperSize=acPRPSLegal

The code successfully changes the properties but the report is still
displayed without the new settings!

Now for the really wierd part...After I run the code and I am looking
at the form with the properties set and the display not reflecting
those changes, I go into Page Setup, change nothing, and click OK and
Poof the changes are updated...

Very twilight zone...

Is there a method that i should be invoking to make the properties
update? The only other way I have gotten this code to work is by
programativcally switching focus away from and them back to the
report...but I really don't want to do that every time I make a change.

Has anyone seen this behavior and does anyone have a solution?

Thanks

Ed
 
Top