report too long...

[Awai]

hi all,

i have a report which is three pages long...as the pages would extend
beyond the maximum "height" for a report i have expanded the report
area to roughtly "a3" size...i have three pages to my report which are
crucial but i'm getting a blank 4th page to give you an idea of what
i'm looking at heres a quick diagram:


----------------------------
| | |
| 1 | 3 |
| | |
----------------------------
| | |
| 2 | 4 |
| | |
----------------------------


pages 1, 2 and 3 all have data on them which i'm setting up to export
as 3page PDF documents. page 4 is a blank page with no data on it - it
prints as a extra page in both my PDFs and my printpreview - is there
any way to set an "end of report" or something similar to my "page
break" to prevent the report from "spilling over" onto this 4th blank
page?


Many thanks in advance,


Geo.

 

[stix4t2]

Access creates these pages because the bottom of the report has extra space, or you put a page break in and left space below it.

 

[Awai]

mmmb so if i remove the apge break and let access spread the report over the A4 pages as it sees fit - it'll ignore the 4th page i'm currently getting as "blank"...

sounds good will give it a try and report back - cheers mate

Geo.

 

[lameid]

You should NEVER use page breaks in reports because of this formating problem. Instead, set the Force New Page property of an appropriate section.

 

[Awai]

many thanks for the advice - i'll remember not to use page breaks and set the force new page property instead. I've still got the problem of the blank page though without the page break.

----------------------------
| | |
| 1 | 3 |
| | |
----------------------------
| | |
| 2 | 4 |
| | |
----------------------------

my report splits over 3 A4 pages now but the area labled "4" above contains no information or data yet still prints blank...ideally id just have the following:

----------------------------
| | |
| 1 | 3 |
| | |
----------------------------
| |
| 2 |
| |
---------------

but obviously i cant "crop" the report page like this, or at least i cant find a way to do it...my pages are portraint so the three cant be put in a single column...

any ideas? thanks for taking the time to answer so far

 

[stix4t2]

Have you set the Force Page Break before section on the first header? or set Force Page Break after section on the last footer?

 

[stix4t2]

By the way, if you used that force page break after, be sure you don't have a report footer or atleast no space in it, this will cause a blank page also.

 

[Remou]

From the diagram, it looks like you are printing a booklet, which always has an even number of pages.

 

[lameid]

I agree with stix4t2. Also check for any extra whire space in any of your headerr and footers. If that isn't it, I'd guess there is something your grouping on that has a blank row in your recordsource.

If that and the other suggestions don't clean it up...
Make a copy of your report and start removing controls / sections until you find out where the problem is. Often once you see where it is, it is easier to fix or at least it is easier to take the time to find that one control that has a height of 0 and crammed up to the top of the section. If it is a section, you can always copy the controls you want, remove the section, add it back and paste in the controls. That will eliminate anything weird... Just remember if you didn't right the report originally, anything you might kill might be doing something.

 

[Awai]

thankyou for all the help - shall see what i can do this morning