saving page setup options

  • Thread starter Thread starter Andrej Gobec
  • Start date Start date
A

Andrej Gobec

Greetings!

I have some trouble setting 'Page Setup' options in my reports. The problem
is that I develop my database on three different machines and when I
transfer it from one to the other all the Page Setup definitions are lost.
So ...

I wanted to write a piece of code to tell my reports how they should look
each time they're being run. You know, margins, orientation and especially
column setup for printing out those labels .... but ...

I couldn't find any VBA commands that would let me refer to any of the Page
Setup properties. It seemed a bit weird to me that with all the objects and
methods and properties I couldn't find any to use with this! So, I'm curious
.... how can I save those properties so they wouldn't reset everytime I carry
my stuff from one computer to the other? Or even if they do reset, how can I
set them again using just a piece of code??

thank you,
Andrej
 
Andrej:

1.) Make sure that your reports are set to use the Default printer by going
to File -> Page Set Up -> Page tab and selecting the radio button that says
"Use Default Printer". If you've got a lot of reports, stop by our web and
look in the code and design tips area under reports for a function that will
allow you reset all your reports to use the default printer.

(Note that if you are designing your report and send it to a printer using
the print dialog and then subsequently save the report, 90% of the time it
will be set to use that specific printer rather than the default, so you've
got to check this after any time you spend designing reports.)

2.) If you need code to set margins, orientation etc, then look on the same
page on our web for that code.....
 
Back
Top