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