Page Break if condition is met

  • Thread starter Thread starter Ashley
  • Start date Start date
A

Ashley

I would like to page break or new page in the report
whenever it see a product number such as 207, 398, or 400.
Can I accomplish this with macro or query?
Please help!

Thanks
 
I would like to page break or new page in the report
whenever it see a product number such as 207, 398, or 400.
Can I accomplish this with macro or query?
Please help!

Thanks
Click to expand...

Just add a page break control to the detail section.
Then code the Detail Format event:

If [ProductNumber] = 207 or [ProductNumber] = 398 or [ProductNumber] =
400 Then
PageBreakName.Visible = True
Else
[PageBreakName.Visible = False
End If
 
Back
Top