Access Report - blank area in page 1 before countinue to page2

[siomay87]

please help

i have a problem in the ms access reporting,
my report have: page header, detail, page footer and report footer
In listing "detail section", the number of line is depend on the data source
I mean long or short in detail section is vary.

The problem is, when the detail is more than 25 line
it will give blank area below the 25th line in page 1, and page 2 continue with report footer.
This blank area in page is cause by space of page 1 is not enough to accept the report footer.
and thats why the report countinue to next page (page2).

if the detail only contain 10 row detail, the room for report footer is enough
and this report will produce in 1 page only

My question is
is there any other way to solve this, i mean how to solve that blank area in continues report ...?
if there is no way, I plan to write some message in those blank area in page 1
"continue to page 2", but how to begin write this script...?


Thanks very much

[nico5038]

I guess the blank area is just too small to show the report footer.
By making the detail section as narrow as possible you might get some more lines on your report.
Another option would be to add a Group and the GroupFooter to displat the totals.
This can be activated by pressing the [= looking button and requires a GroupLevel field. Then the Report footer can be dropped and for a GroupLevel there are properties to keep them together.

Nic;o)