Marshall,
Thank you for responding! You sent me in the correct direction to solving
the problem. I have a subreport in the group footer. The subreport has no
records in this situation. The can shrink property of the subreport control
was set to Yes but the can shrink property of the group footer was set to
No. This was what was causing the third page with the labels at the top but
no records for that group. I set the can shrink property of the group footer
to Yes and the report works correctly now. Thanks again!
Melissa
"Marshall Barton" <ma*********@wowway.com> wrote in message
news:ka********************************@4ax.com...
Melissa wrote:
I have a grouped report that starts a new page at each group. All the
fieldlabels for the report are in the group header because there is a
subreportin the top part of the report that needs to grow (The subreport can't
growin the page header!). Each page holds 21 records. I need the labels on
eachpage so I set the Repeat property of the group header to Yes. When a
grouphas 42 records, I get two pages of records with the labels at the top.
Thisis good! However, because Repeat is set to Yes, I get a third page with
thelabels at the top but no records for that group. What do I need to do to
have the report not create the third page for that group but rather
displaythe next group on the third page?
That third page happens because there is actually some part
of the group to display. It's probably just a little blank
area at the bottom of the last (detail?, group footer?)
section in the group. Locate and remove the unused space.
--
Marsh
MVP [MS Access]
