Avoiding Widows and Orphans (1 Viewer)

A

Access_Help

Registered User.

Local time

Today, 15:22

Joined

Feb 12, 2005

Messages

136

• Aug 16, 2018

• #1

I have a report where data is grouped by region.
The data for the region at the bottom of the first page is split over two pages.

I want to avoid split data on any part of the report.

Is there a method to avoid widows and orphans?

 

Ranman256

Well-known member

Local time

Today, 18:22

Joined

Apr 9, 2015

Messages

4,339

• Aug 16, 2018

• #2

in the Relationship settings,
dbl-click the join line between tables,
set to Delete related records (to prevent orphans)

 

A

Access_Help

Registered User.

Local time

Today, 15:22

Joined

Feb 12, 2005

Messages

136

• Aug 16, 2018

• #3

Ranman256 said:

in the Relationship settings,
dbl-click the join line between tables,
set to Delete related records (to prevent orphans)

Click to expand...

I updated the relationship settings and re-opened the report. There is still a split in some data.

 

jdraw

Super Moderator

Staff member

Local time

Today, 18:22

Joined

Jan 23, 2006

Messages

15,379

• Aug 16, 2018

• #4

see if this helps
https://msdn.microsoft.com/en-us/vba/access-vba/articles/section-keeptogether-property-access