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

[matt753]

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

[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.

[matt753]

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.