Avoiding Widows and Orphans

[Access_Help]

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]

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

 

[Access_Help]

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

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

 

[jdraw]

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