When page runs out force new page

[Costefran]

Hello

Is there any way access can identify when a report page is filled and force a new page to prevent subreports and controls / labels being spread across two pages

Many thanks

 

[ProgramError]

use a page break

Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.

 

[Costefran]

Thanks

I'm sure your answer is correct but how do I automate a page break

E.g. my subreports can shrink or grow depending on the number of records so would I need access to know when it cannot fit all the subform on one page and force a new page and at other times where there are fewer records then access will not force a new page

Thanks