469,572 Members | 1,243 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,572 developers. It's quick & easy.

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

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
1 1964
3,080 Expert 2GB
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.

Similar topics

7 posts views Thread by John | last post: by
4 posts views Thread by Dale Ring | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.