Keeping data together across pages in a report

I have an Access 2007 report. It displays counts of students by graduation
year, and is grouped by teacher...something like this:

Teacher name
2010 3
2011 4
2012 3
2013 3
Total: 13

There are 85 teachers, so the report spans a dozen or so pages. Now, even
though I have "Keep together" selected in the property sheet of each section
of my report, there are page breaks in the middle of each section. How do I
absolutely, positively force everything between "teacher name" and "total" to
stay together on teh same page without forcing a page break after each
teacher's section?

Thanks

Pete

In report design view, open the Sorting And Grouping pane, and select the
group based on the Teacher field.

You will see an option in the Sorting'n'Grouping pane (not in the Properties
box), for:
Keep whole group together on one page.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"pruckelshaus" wrote in message
...
I have an Access 2007 report. It displays counts of students by graduation
year, and is grouped by teacher...something like this:

Teacher name
2010 3
2011 4
2012 3
2013 3
Total: 13

There are 85 teachers, so the report spans a dozen or so pages. Now, even
though I have "Keep together" selected in the property sheet of each
section
of my report, there are page breaks in the middle of each section. How do
I
absolutely, positively force everything between "teacher name" and "total"
to
stay together on teh same page without forcing a page break after each
teacher's section?

Thanks

Pete

Group by teacher name and then set the group's Keep Together property to Whole
Group.

You set the grouping using the Sorting and Grouping Dialog (View: Sorting and
Grouping ...)

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

pruckelshaus wrote:
I have an Access 2007 report. It displays counts of students by graduation
year, and is grouped by teacher...something like this:

Teacher name
2010 3
2011 4
2012 3
2013 3
Total: 13

There are 85 teachers, so the report spans a dozen or so pages. Now, even
though I have "Keep together" selected in the property sheet of each section
of my report, there are page breaks in the middle of each section. How do I
absolutely, positively force everything between "teacher name" and "total" to
stay together on teh same page without forcing a page break after each
teacher's section?

Thanks

Pete

Brilliant, thanks!