Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-16-2018, 08:47 AM   #1
Access_Help
Newly Registered User
 
Join Date: Feb 2005
Posts: 67
Thanks: 15
Thanked 0 Times in 0 Posts
Access_Help is on a distinguished road
Avoiding Widows and Orphans

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?

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Access_Help is offline   Reply With Quote
Old 08-16-2018, 08:55 AM   #2
Ranman256
Newly Registered User
 
Join Date: Apr 2015
Location: KY,USA
Posts: 3,123
Thanks: 0
Thanked 682 Times in 667 Posts
Ranman256 will become famous soon enough Ranman256 will become famous soon enough
Re: Avoiding Widows and Orphans

in the Relationship settings,
dbl-click the join line between tables,
set to Delete related records (to prevent orphans)
Ranman256 is offline   Reply With Quote
Old 08-16-2018, 10:01 AM   #3
Access_Help
Newly Registered User
 
Join Date: Feb 2005
Posts: 67
Thanks: 15
Thanked 0 Times in 0 Posts
Access_Help is on a distinguished road
Re: Avoiding Widows and Orphans

Quote:
Originally Posted by Ranman256 View Post
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.

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Access_Help is offline   Reply With Quote
Old 08-16-2018, 10:13 AM   #4
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 11,571
Thanks: 57
Thanked 1,874 Times in 1,824 Posts
jdraw is just really nice jdraw is just really nice jdraw is just really nice jdraw is just really nice jdraw is just really nice
Re: Avoiding Widows and Orphans

see if this helps
https://msdn.microsoft.com/en-us/vba...roperty-access

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft widows xp help Coreman38 Windows 8 09-18-2012 04:31 PM
Safeguard against orphans spikepl Forms 4 10-27-2011 04:38 AM
Excel Orphans stuck in Memory wsthomas1 Modules & VBA 3 04-05-2011 06:46 AM
Access 2003 ODBC Widows not opening lcky General 1 04-30-2007 11:36 AM
Subform Orphans damian Forms 0 11-24-2005 02:48 AM




All times are GMT -8. The time now is 12:10 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World