I have built a report in access and have a group footer with the property "New Row or Column" set to "after section". My problem herein lies. When it prints it puts a huge space between the groupings. Is there anyway to reduce this grouping. I have several projects that list in this report, i need sum totals by project number, i have this working but i can't get rid of the huge gap between project #'s. Any help would be greatly appreciated.

I have found setting the property 'Can shrink' on the 'Format' tab of each Report Sections works for me.

Cheers Ray