S
Steve S
I have a report to record the results of a tri-athlon type sporting event.
The default paper size is 8.5 x 11 landscape. when there are only 2 judges
for 3 events OR 3 judges for 2 events the report is perfect. the problem is
when there are 3 or more events and/or 3 or more events. In thiscase (about
30% or the time) the report spills over onto a second page and the results in
a cell may be split between pages. this makes it very difficult to line up
and read.
Is there a way to dynamicaly (sp??) change the paper size to Legal with VBA
code? I am able to shrink and grow the report horizontaly but can't change
the paper size .
Any and all help is appreciated
The default paper size is 8.5 x 11 landscape. when there are only 2 judges
for 3 events OR 3 judges for 2 events the report is perfect. the problem is
when there are 3 or more events and/or 3 or more events. In thiscase (about
30% or the time) the report spills over onto a second page and the results in
a cell may be split between pages. this makes it very difficult to line up
and read.
Is there a way to dynamicaly (sp??) change the paper size to Legal with VBA
code? I am able to shrink and grow the report horizontaly but can't change
the paper size .
Any and all help is appreciated