Landscape report shows and prints as portrait

[flaviooooo]

Hi,

I have seen this on these forums before, but never found an answer to this annoying problem.

We are using Access 2003 (SP2), and several of our reports (if not all) that are formatted as Landscape, show on screen and print out as portrait when you first open it. If you close it and re-open, they often show OK.

When I check the print settings, the report is clearly set to landscape.

I have also checked the 'Track Name Autocorrect Info' setting, but it was turned off. I turned it on and off to see what would happen, but the result was the same.

I have also tried the small code Application.Printer.Orientation = acPRORLandscape on opening the report, but still no result.

Any help would be greatly appreciated...

 

[lameid]

Never heard of it...

Have you tried a different printer/driver? What happens if say you manually add a HP Laserjet 4+ on LPT1 and make it your default printer.

First, Does the report default to printing to the new default printer or pick up the original?

Second, does it fix the problem?

 

[Knicks]

I've had this problem recently, with a database created in 2000 format but new users with 2003. Reports set to Portrait print Landscape on the 2003 machines. Everything I've read points to bugs in 2003. I think whatever features they are offering new aren't worth the headaches of the newest version (yet)

 

[lameid]

I do not have this problem but I am using the 2002/2003 file format.

Knicks, perhaps if you converted your database to the newer format it would work? I'm suggesting this as just a test as it sounds like you have a mixed environment. On the otherhand if it works you could probably keep your data in 2000 format a frontend for development in 2000 and give your 2003 users a frontend converted to a new file format. I'm assuming that a backend in 2000 format won't break it.

Good luck and happy hunting to both of you.

 

[flaviooooo]

I seem to have solved it for now? I checked my default printer and saw that the orientation was set to 'Portrait' I changed it to landscape, and now the issue seems to be gone.
Portrait reports still look good and now the landscape one
do what is expected as well.

I'll keep you posted if it changes back