Avoid one Line on Next Page

[ertweety]

I have a report that shows employees by department. With each department, a new page is begun. Therefore, some departments will need 1 page while others will require 2. My problem is that I have a few departments that fit mostly on one page but one or two lines spill to the next page. is there anything I can do to avoid only one or two lines on the following page?

 

[vbaInet]

One or two lines of what? Records or actual lines?

 

[StuckInLiverpool]

Are you saying that if a page can contain 30 lines, you have some departments with 32 records, so the last 2 lines go onto the next page?

 

[ertweety]

That is correct.

 

[vbaInet]

So where should the other 1 or 2 records spill to? They should just be disregarded?

Decrease the height of your controls and sections so it all fits in.