Started using Access 2016.
I have a report that has boiler plate text and added a subreport. All is well if the subreport has at most 2 records (screen shot). I would like to specify a page break (where highlighted in screen shot) on the main report if the subreport has more than two records. I tried this code in the Detail_Print:
Didn't seem to work for me. Page still breaks regardless of true/false. I stepped through the code and it is following the logic. Another suggestion said to set the page break visible property to false, I did not see that option in the property sheet of the page break control. Since the page break doesn't relate to grouping I don't think can use the keep together or force new page after stuff.
I have a report that has boiler plate text and added a subreport. All is well if the subreport has at most 2 records (screen shot). I would like to specify a page break (where highlighted in screen shot) on the main report if the subreport has more than two records. I tried this code in the Detail_Print:
Code:
If Me.txtListCount > 2 Then
Me.PageBreak120.Visible = True
Else
Me.PageBreak120.Visible = False
End If