On Format sanity check

K

KJGinNC

Hello,

I just wanted to do a sanity check. I've created a report that shows the
summary for a set of records and the details for a specific subset of the
records.
(Thanks to numerous posting and responses on the board and to the authors of
AC2000 Developers Handbook).

I had to use the On Format event for both the Section Header and the Detail
or else the Section header repeated. Is that right? Here's my code. Is
there a better way?

Thanks!

Karrie

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.txtBypassDetails = "ok" Or IsNull(Me.txtBypassDetails) Then
Cancel = True
End If

End Sub

Private Sub GroupHeader2_Format(Cancel As Integer, FormatCount As Integer)
If Me.txtBypassResults = "ok" Or IsNull(Me.txtBypassResults) Then
Cancel = True
End If
End Sub
 
Top