Someone please help me stop the column breaks!!!!

[Cgradio]

I am going insane! I have a two-table db which we (church) use for membership records. I'm working on a printed directory. The Report pulls queried elements and seems to pull correctly from both tables.
Table 1 (Families) contains the information that is common to the entire family (label name, last name, address, home phone, etc. and DOES have a primary key). Table 2 (Individuals) is linked to Table 1 and contains information for the individuals in the family (personal name, cell phone, email, birthday, etc.).

Sorting and display are perfect in a single-column format. When I make it a 2-column print it puts a column break between each individual. Here's my report setup:
Report header - just has logo and "Directory"
Page header is empty
Primary Key Header contains info from Table 1 (Families)...formats fine...prints fine [Grouped on Primary Key - Sorted on Family Name, then Label Name, then HeadofHousehold, then Personal Name]
The Grouping is set to "keep whole group together on one page", but I've tried both options...neither has an impact on this problem.
Detail contains the personal information for individuals within that family (Personal Name, Cell Phone, Email, Birthday)
Primary Key Footer is empty.
Page Footer simply has the page number (x of x)
Report Footer prints the date of print

My settings (the ones I've messed with until I'm nearly blind) on Detail are:
CanShrink Yes
CanGrow Yes
KeepTogether Yes
ForceNewPage None
NewRowOrCol None [although I have tried Before, After and Before & After]

On Primary Key Header:
CanShrink Yes
CanGrow Yes
KeepTogether Yes
ForceNewPage None
NewRowOrCol None [although I have tried Before, After and Before & After]

One Primary Key Footer:
CanShrink Yes
CanGrow Yes
KeepTogether Yes
ForceNewPage None
NewRowOrCol None [although I have tried Before, After and Before & After]

It would appear that I've selected a new column Before the Detail section, because that's where the break is happening. Immediately after the Family details, the first detail is moved to the next column. Each following detail line under the same Primary Key is pushed to the next column. I've made sure my print columns are wider than the report width, so that's not the issue. I've tried changing the Grouping settings (at the bottom), and the Detail's KeepTogether, NewRowOrCol and CanShrink/CanGrow.



Please help! I'm at the end of reading page after page of advice on other forums and Microsoft's site has proven pitiful for this issue.

Screenshot:

[Cgradio]

Forgot to mention...Windows 7-64 bit
MS Access 2010-32 Bit

[June7]

Want to provide db for analysis? Follow instructions at bottom of my post.

Why the primary key group?

[Cgradio]

I added the primary key. Originally I had it Grouped by Family Name AND Grouped by Label Name. I thought having two groupings may have been causing the issue, so I added a primary key so I could Group on only one field. I would gladly provide the database, but want to be cautious how "wide" I share it. It contains address/phone/email for every member...but to "remove confidential data" would be to remove all of the data. Is there another way?

[Cgradio]

OK...Here is a copy of the database with 11 fake families input.
Also attached is the print results I'm getting.

BTW...the site told me that 500KB was the limit for this file type...that's why I zipped. The unzipped is 596K

[ssanfu]

Keep in mind that I am using A2000........ I am not sure where the following will be found in A2010. ( I can look tonight).

Check on the column layout settings.

In the menu, goto FILE/PAGE SET UP.
A dialog window opens with 3 tabs - Margins / Page / Columns
Click on the Columns tab
Under "Grid Settings", you might have 2.
At the bottom of the tab, under "Column Layout", you have 2 options: "Down, then across" or "Across, then down".

Make sure that "Down, then across" is selected.

[Cgradio]

I have 2 columns and have tried both versions (prefer the Z). Neither rendered the desired result.

Keep in mind that I am using A2000........ I am not sure where the following will be found in A2010. ( I can look tonight).

Check on the column layout settings.

In the menu, goto FILE/PAGE SET UP.
A dialog window opens with 3 tabs - Margins / Page / Columns
Click on the Columns tab
Under "Grid Settings", you might have 2.
At the bottom of the tab, under "Column Layout", you have 2 options: "Down, then across" or "Across, then down".

Make sure that "Down, then across" is selected.

[June7]

I opened the Photo Directory Listing report in Print Preview and it displays as 2 columns over 2 pages. (Windows XP Access 2007).

It was set for across then down so I switched to down then across. Displays all 11 on 1 page (there is a second page with only date and page number, I think that is report footer so I moved the date to report header and second page goes away) and looks better and less confusing.

Will have to try later with Windows 7 64bit and 2010 32bit

EDIT: update, observed same behavior with Windows 7 64bit and 2010 32bit as I did with 2007

Cannot replicate the issue.

[Cgradio]

Thanks for the help!
I got the Down, then Across to work. Now, I have it breaking in between the detail lines. Settings for every section are "Keep Together Yes". My Group and all Sorts are set to Keep Whole Group Together on One Page.

How do I keep it from breaking to next column in between detail lines?

Thanks again.

(If you need to test on the sample db uploaded, you could change to Landscape to get the columns to wrap with the small number of records.)

[June7]

That I don't know, never have understood the Keep Together property.