report page setup

degremont

Registered User.
Local time
Today, 07:45
Joined
Jun 25, 2008
Messages
14
I define one report in PAGE SETUP / PAGE as Landscape, but when I reopen the ACCESS file and open the report it is automatically diplay as Portrait.
The strange thing is if I cloase the report and reopen it, it is displayed as Landscape.
I'm crazy about this...
HELP....
 
I have exactly the same issue with my report opening portriat the first time, then landscape the next, I am running Access 2003.

I tried turning off the "Name Autocorrect" options in Tools/Options but it hasn't fixed it, any other ideas?

Degremont, did this fix it for you?

Help much appreciated :)

-------------------------------------------------------

UPDATE: I have temporarily fixed the issue by changing the code that was automatically generated by Access. I simply run OpenReport command twice as follows:

Dim stDocName As String
stDocName = "RepairDetails"
DoCmd.OpenReport stDocName, acViewPreview, acWindowNormal
DoCmd.Close
DoCmd.OpenReport stDocName, acViewPreview, acWindowNormal
 
Last edited:
Thanks Pat, I have Access 2003 SP2, thats down to our IT dept. Therefore I will stick with my modified code that opens the report twice.
 

Users who are viewing this thread

Back
Top Bottom