Remove Blank Pages

  • Thread starter Thread starter aclelland
  • Start date Start date
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
 
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.
Click to expand...
Why don't you split your report into three reports and print the on demand?


mfG
--> stefan <--
 
hi Alan,



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

mfG
--> stefan <--
Click to expand...

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.
 
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.
Click to expand...
Why don't you use a report table (OrderNo, Caption, Content) and render
it (insert the data) before printing/viewing it.


mfG
--> stefan <--
 
Back
Top