Remove Blank Pages

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
 
S

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 <--
 
A

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top