not spliting grouped data

C

Charlie German

I have a report in Access 2003 where the data is grouped, there are several
seperate things in the group with lots of lines for each grouped item. To
make the report look more proffesional I would the page to stop at the end of
one of the item lines and carry the next group item and its lines over to the
next page for example:

A
1
2
3
4
5
B
1
2
3
4
5
C
1
2
3
D
1
2
-------------------------page break------------------
3
4
E
1
2
3
I would like the page break to be set so all of "D" goes to the next page
the problem is I never know how many lines are going to be in a group a head
of time. I also don't want a half page of dat on the first page. The other
thought that would work for me is if the group name could be carried over to
the next page if it happen to be in the middle of the group item.
 
J

John Spencer

And if you want to have the group header repeated instead, then set the group
header's Repeat Section property to Yes. This will "repeat" the group header
at the top of the page if the group is split over multiple pages.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
C

Charlie German

Marshall,
Thanks you very much for your quick response. This solved my problem.
 
C

Charlie German

John,
Thanks for responding do both option work together? Repeat Section
property to Yes & group's KeepTogether property to Whole Group.
 
J

John Spencer

They should. Try it and see.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top