In MS Access 97 I am attempting to force a page break in a subreport To control the Subreport size. What is currently happening is that the number of lines in my subreport will cause the subreport page length to exceed the Main report, and run over the lower main report data.
I'm usung the sample code as shown in the Access 97 help files, but no success. The sample code as shown is:
If Me![Counter] = 10 Then
Me![PageBreak32].Visible = True
in the detail section "On Print" event where I want the break, with the code of:
Me![PageBreak32].Visible = False
In the report header "Format" event.
I don't understand if the [Counter] is a built-in function, or I have to create this.
Thanks for any assistance.