Can I adjust top margin on they fly?

[Guest]

From my Switchboard form I batch run a large number of reports with varying
lists and a Sum at the bottom. On a few individual reports the list is just
long enough to push the Sum to the top of the next page, so I reprint each of
those singly with different margins. So far my method is to open the report
in Design mode, adjust the page margin, and reprint.

Is there a programmatic way to do this from a control on my Switchboard?
The Switchboard already allows me to select a single report, rather than the
whole batch, and an additional control letting me change the report margins
would make my life complete.

Thanks!

 

[Marshall Barton]

From my Switchboard form I batch run a large number of reports with varying
lists and a Sum at the bottom. On a few individual reports the list is just
long enough to push the Sum to the top of the next page, so I reprint each of
those singly with different margins. So far my method is to open the report
in Design mode, adjust the page margin, and reprint.

Is there a programmatic way to do this from a control on my Switchboard?
The Switchboard already allows me to select a single report, rather than the
whole batch, and an additional control letting me change the report margins
would make my life complete.

In A2002 and later, reports have a Printer property:
Me.Printer.TopMargin = 720 '1/2 inch

 

[Guest]

Thanks, Marsh. I forgot to mention I am using 2003. That should solve the
problem.