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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Delete Multiple Page Breaks w/in Selected Rows 6
conditional page break 3
How to print a page in between of every report page? 3
Printing a Repeated Section Messege like "Continued" 3
Unwanted page break 5
Conditional Page Breaks 1
Page Break cause Blank pages 1
Page break between sub reports of a sub report 1

Back
Top