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

How to add a page break to a report once it has too many items

P: 91
Right now I have an invoice report than works fine for < 10 items on the order, but once there is more it will have the header on the first page with some of the items, then the rest of the items on the second with the footer at the bottom. (the report only has one header and one footer no matter how many pages)

All items are in the detail section, header and footer information are in appropriate positions.

How I want it to be is: each page has a header and footer, then all the items show up in the detail section. Once there is say 8 items or more it will insert a page break. Seems like access should do this automatically as this is the logical way if you have a header and footer.


I know you can insert a page break then activate it in code but i'm not sure exactly how to do this.

Thanks
Jun 24 '10 #1

✓ answered by gershwyn

A report header will only appear once, and adding page breaks isn't going to help that. What you want to do is create a page header instead. Move everything that you have in the report header to page header, and do the same for the report footer. (You may need to right click to show the pager header/footer. I'm not sure which version of Access you're on.)

Page headers and footers should behave how you'd expect them to, and Access should take care of where the page breaks should occur for you.

Share this Question
Share on Google+
2 Replies


100+
P: 122
A report header will only appear once, and adding page breaks isn't going to help that. What you want to do is create a page header instead. Move everything that you have in the report header to page header, and do the same for the report footer. (You may need to right click to show the pager header/footer. I'm not sure which version of Access you're on.)

Page headers and footers should behave how you'd expect them to, and Access should take care of where the page breaks should occur for you.
Jun 24 '10 #2

P: 91
Awesome thats just what i was looking for, I've done that before when i've made reports, thats why I thought this was just automatic.
Jun 24 '10 #3

Post your reply

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