Link to home
Start Free TrialLog in
Avatar of DaveRoehrman
DaveRoehrmanFlag for United States of America

asked on

Access 2007 report preventing orphaned lines on an otherwise blank page

Some of my reports end with a single line on the last page.  Is there a way to create a conditional page break to prevent this?
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Right-click on any section header bar and choose Properties.
You have KeepTogether and Force New Page properties avaialable.
Avatar of DaveRoehrman

ASKER

I use Keep Together and Force New Page, but...

...If my report footer has just one line, therefore appears alone on the last page, is there a way to include one of the items in the list on the previous page?

In other words, can I in some way state, "Do not allow a single line to be printed on the last (or any) page."?
SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
But again, you may need to provide a bit more info as to the exact structure of your report...
You're Welcome