A
aclelland
Hi,
I am currently creating a dynamic report which can be a variable
length depending on options the user selects. This means the form can
be between 1 and 3 pages in length.
The problem I am having is that if I set the report to be 1 page in
length I get an error if a control is placed on the second page
(because the form is not long enough) and if I set the report to be 3
pages in length I geet 2 blank pages when I print the report.
The controls are created and moved dynamically using VBA scripting.
The two solutions I can think of is some way to increase the report
size using VBA or having access cull blank pages when it comes to
print the report out.
I have included two sample reports to show the problem.
http://aclelland.googlepages.com/Report1.pdf
http://aclelland.googlepages.com/report.pdf
Thanks,
Alan
I am currently creating a dynamic report which can be a variable
length depending on options the user selects. This means the form can
be between 1 and 3 pages in length.
The problem I am having is that if I set the report to be 1 page in
length I get an error if a control is placed on the second page
(because the form is not long enough) and if I set the report to be 3
pages in length I geet 2 blank pages when I print the report.
The controls are created and moved dynamically using VBA scripting.
The two solutions I can think of is some way to increase the report
size using VBA or having access cull blank pages when it comes to
print the report out.
I have included two sample reports to show the problem.
http://aclelland.googlepages.com/Report1.pdf
http://aclelland.googlepages.com/report.pdf
Thanks,
Alan