Page Break if condition is met

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
 
F

fredg

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
 
Top