Setting a page break on grouped items 1

[AccessGuruCarl]

I have a report grouped as such...
Report Header - Page Header

Grouping Starts Here.
RunNo Header

HeatNo Header

Detail Section
- Holds Lane and Car Info

Page Footer

I'm trying to set a page break if all the data for the current HeatNo (detail section) if the complete heat data won't fit on that page. Then move that heat to the next page. I hope this makes sense! Any Ideas....

Example Output..

Run # Heat # Lane # Car #

1
1

1 34
2 35
3 22
4 12

1
2
1 45
2 44
3 35
4 35

1
3
1 45
2 44
3 35
4 35



AccessGuruCarl
Programmers helping programmers
you can't find a better site.

 

[belovedcej]

Check out the sorting and grouping dialog box. Go to the HeatNo group and change the Keep Together option to "whole group.

 

[AccessGuruCarl]

Thanks....

I knew it was a simple fix.

But I never recall that!

Here's a Star!


Thanks Again.

AccessGuruCarl
Programmers helping programmers
you can't find a better site.