Keeping Groups together (1 Viewer)

[statsman]

I'm using Access 2007.
I have a report for the players in a league. There are only 4 members per team and the data is pretty simple. Just the name, team and the games played and won.
I have them grouped by team and in two columns in the report.
What I would like to do is keep each team together, either in the column or the page. What I am getting now is run over with the same team in two columns or on two pages.
Is there a way to tell the report that if there isn't enough space left in a column or on a page, to go to the next column or page?

 

[statsman]

So I scrolled down a big and found wiklendt's contribution on this subject and it works perfectly.
Amazing function that search button.
Sorry if I wasted your time.

 

[jdraw]

Glad you have a solution. For reference I think this is the link involved.

 

[theDBguy]

Hi. Just for future reference, did you end up using the "keep group together" option?

Edit: Oops, too slow...

 

[statsman]

Hi. Just for future reference, did you end up using the "keep group together" option?

Edit: Oops, too slow...

That was what I used. I almost never use columns or grouping in reports so I wasn't even aware this function existed.