CAN PAGE SETUP BE CHANGED WITH CODE?

[Roy]

I use Access2000 to generate a label report. I used page setup to set the
columns, spacing etc. but when I run the program, the page setup defaults to
columns = 1 rather than columns = 3 and the spacing changes also. How do I
use code to make sure the page settings don't default to other amounts?

 

[Larry Linson]

There were some reporting errors in Access 2000 that were corrected by one
of the three (3) Service Packs. If memory serves, one or more of those
errors involved losing settings. Access 2000 was arguably the worst release
ever, in its original state, but with all three Service Packs applied, seems
solid and stable (though it is now "out of support"). Make certain all
Service Packs and hotfixes have been applied... or, pick up a copy of Access
2003, apply all its Service Packs, and try that. I won't suggest Access
2007, because with its UI differences, converting your application might be
a daunting task.

Larry Linson
Microsoft Office Access MVP

I use Access2000 to generate a label report. I used page setup to set the
columns, spacing etc. but when I run the program, the page setup defaults
to
columns = 1 rather than columns = 3 and the spacing changes also. How do
I
use code to make sure the page settings don't default to other amounts?

__________ Information from ESET Smart Security, version of virus
signature database 4002 (20090411) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4002 (20090411) __________

The message was checked by ESET Smart Security.

http://www.eset.com