asked on

MS Access 2010 - Group Header repeats

I have a report with a Group header and on some pages it will show the group header at the bottom of the page with no detail records I assume because it hit the end of the page and no more detail records can be displayed...On the next page the Group header is repeated along with the detail records.

How do I force MS Access not to display a Group Header at the bottom of the page if there are no detail records to be displayed. My settings for the group header are:
Keep Tog: Yes
Repeat Section: Yes
Force New Page: None

ASKER CERTIFIED SOLUTION

peter57r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

upobDaPlaya

ASKER

I went to Report Header and changed it to Keep Together from Yes to No and I still have orphans ?

upobDaPlaya

ASKER

When you say report group settings, are you referring to the "Group Header"...I do not see any other Group sections I can alter ?

peter57r

You are in completely the wrong place.
With the report in design view click the Group/Sort option on the ribbon- the grouping details appear at the bottom of the design screen and one of those options is to keep the group together.

upobDaPlaya

ASKER

Thanks that worked ! However, what is the difference between what is available on the ribbon vs when I select on the Group Header Section and then click on properties...It seems like some options are the same on the ribbon method vs selecting the group header/properties

peter57r

As I said in my first response...

Setting 'Keep together' on the group header does that but only that - keeps the group header together.

.... so it stops a multi-line group header from being split across two pages.

upobDaPlaya

ASKER

Thanks...apologies for struggling on this one..but I get it now..