Miscrosoft Access - Problems with Page setup in reports

[NaoTriste]

I have just converted an Access 97 system into Access 2002 and have this problem where the first time a report is printed , regardless of the way it was setup in design mode it always previews/prints in Portrait mode, even if the orientation is again specified in the Report open event.

I had to do a work around where, on Login, I open a randomly chosen report in design mode, hide it, set it to landscape and then preview it (still hidden). This is all transparent to the user so by the time they choose a report to print it everything is ok.

I know this is not a bug in Access 2002 as I created a small databse with one report which works perfectly fine so it must be something about the system, some setting, etc that makes it behave this way.

I would dearly love to fix this instead of doing a workaround even if it was just to get one over a smart ass (who is actually very smart) contractor who I am working with who likes to think that I am less technical because I am a woman ! Can anybody help ?

 

[mark929]

Did you ever find a solution to this problem? I am having the same problem.

Thanks

Mark
robertsm@oro.doe.gov

 

[NaoTriste]

As I said I did a work around but all it means is that I am accomodating the problem not really solving it.
All I did was to create a bit of code (as follows) which is executed as soon as the user logs in into the system:

DoCmd.OpenReport "rptSetOrientation", acViewDesign, , , acHidden
Reports("rptSetOrientation&quot.Printer.Orientation = acPRORLandscape
DoCmd.OpenReport "rptSetOrientation", acViewPreview, , , acHidden
DoCmd.Close

_________________________________________________________
Also created new report (rptSetOrientation)
to be used in the code above. Containing a label with a self explanatory note and set to landscape.
This will never be visible to the user as it is always in hidden mode.

After this code is executed all reports are previewed/printed as they were set & saved in design