Column Breaks in a MS Access Report 2

[CSADataCruncher]

I need help with understanding and perhaps coding a column break in an Access Report. For those of you who have helped me before, yes it's me the sports card collector lady again. The report is set up to pull on a query that retrieves a certain football team, then the information is grouped by year, Card Company, Card Company Set Name, and then by Card Number.

The year and Team name make up the title for each page. Then I have 2 columns with a new "header" for each company name/set of cards.

Here is my problem... The company header is set to keep together with first detail and by doing this I sometimes end up with an "orphaned title" at the top of a new column. I've tried "Keep whole group together" and then I end up with 2 columns of 25 items on a page that is set up to handle 70 rows per column (meaning the bottom half of the page is blank). Currently, the orphaned title looks better than a bunch of half blank pages.

If I don't use a "keep together" option, the 2nd column usually ends up without a header. Is there a way to be sure there is always a header at the top of a new column without having orphaned headers?

Peggy
CSADataCruncher

 

[genomon]

Try these property settings in the group header:
NewRowOrCol = BeforeSection
RepeatSection = True (or yes on the property page)
Perhaps one of the two or both may help.
Good luck!

The Microsoft mascot is a butterfly.
A butterfly is a bug.
Think about it....