Page Layout changes, landscape/portrait and number of columns

[MightyRoo]

Hello all,
Our DB is spilt FE/BE in Access 2000.
I have an issue with the page layout changing from landscape to portrait and the number of columns changing from 3 to 1 on reports (labels).

I can't even figure out where to start as a report will open and print correctly and then you open it a second later and it's changed layouts. I can't figure out what causes the change.

The problem is happening on multiple pc's.

It looks like I can use the prtdev to change it seems like there is an easier way.

Will a print driver change things like this automatically?
The report preview does change also.

Any help would really be appreciated.

Thanks,
Scott

 

[dhookom]

I expect this is a well known issue with Access reports without all the patches and/or service packs. You can either install the service packs or possibly select Tools->Option-> and un-check all Name Autocorrect boxes.

Duane
Hook'D on Access
MS Access MVP