Page break if grouped items don't fit on page

[accessbro]

I have a report that groups project by project manager name. On the first page, it shows projects for Carl, Darryl and Rick. Carl and daryls projects all show on the first page but only some of ricks projects show up on the first page and the rest show on the second page.



I want to have a page break so that ricks projects are all on the second page while Carls and Daryls projects stay on the first page. Is there a condition that can check if all the items grouped by the project manager will fit on the page?

[NTC]

yes look around in your Grouping properties - there is a 'keep together' selection you can experiment with

[accessbro]

yes look around in your Grouping properties - there is a 'keep together' selection you can experiment with

I found this last night:

http://bytes.com/topic/access/answer...detail-records

It does exactly what I need. Thanks for the suggestion.