Remove Blank Pages

[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

 

[Stefan Hoffmann]

hi 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.

Why don't you split your report into three reports and print the on demand?


mfG
--> stefan <--

 

[aclelland]

hi Alan,



Why don't you split your report into three reports and print the on demand?

mfG
--> stefan <--

The user wants to be able to choose the exact information which they
print out so they want to be able to choose

Name
RefNo
Creator

or

Name
Date Created
RefNo
Creator

or

RefNo
Start Date
End Date

Since there are over 30 fields to choose from it's not possible to
create reports for each combiniation.

 

[Stefan Hoffmann]

hi Alan,

The user wants to be able to choose the exact information which they
print out so they want to be able to choose
Name
RefNo
Creator
Since there are over 30 fields to choose from it's not possible to
create reports for each combiniation.

Why don't you use a report table (OrderNo, Caption, Content) and render
it (insert the data) before printing/viewing it.


mfG
--> stefan <--