By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,437 Members | 1,599 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,437 IT Pros & Developers. It's quick & easy.

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

P: 1
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
Apr 19 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,072
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.

Apr 23 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.