'03 DB Prints/Pvws Landscape Rpt in Portrait

[Guest]

I have a DB built in '97.
There are about 10 users; using command buttons to run, preview & print
their reports. All reports are Landscape...
4 of those users were upgraded to XP/Access 2003.
2 of those 4 have no problems. They open '03 then open the '97 version
without converting.
1 user when she tries to preview/print the reports, they preview and print
in Portrait.
I have tried making a copy the the database, converting it to 2003, changing
the design of the reports in 2003 db and they still preview/print in Portrait.

Any thoughts?? I know it is not the DB is something with her set up, but our
technical support doesn't know anything.

Thanks.

 

[Allen Browne]

In A2003, make sure the Name AutoCorrect boxes are unchecked under:
Tools | Options | General
Incorrect report orientation is just one of the problems that will fix:
Failures caused by Name Auto-Correct
at:
http://allenbrowne.com/bug-03.html

When you open the report in design view, make sure the report is not
designated for a particular printer:
File | Page Setup | Page | Default Printer
Designating to a particular printer could cause problems if a user does not
have that printer, or has a slightly different driver for that printer.

If all 10 users are using the same database, you really need to split it
into a back end (Access 97 MDB that contains just the tables, in a shared
folder), and front ends. The front ends contain all the other objects
(queries, forms, reports, ...), with linked tables (connected to the back
end.) Each user has their own local copy of the front end. The A97 users
will have an A97 front end, and the A2003 users will have an A2003 front
end. If that is a new concept, see:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html