Report Printing

[JJT]

Is there a way to use VB to print a report so that I get a new page with header everytime a certain value changes ?

 

[pdx_man]

Would this be an alternative to using the Force new page property in a Group Header? That's the way I do it.

Under the View menu, select Sorting and Grouping and put your field that is going to change. Have a group header. Adjust the Force new pageproperty of the new header.
OR
If you're looking for a specific value, try:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.loannum = 257032 Then
Me.PageBreak351.Visible = True
Else
Me.PageBreak351.Visible = False
End If
End Sub

Private Sub Report_Open(Cancel As Integer)
Me.PageBreak351.Visible = False
End Sub

You can tweak it from here ...

HTH