I have read many threads but have not yet found the answer, this should be easy!!!
I want to skip a detail line if the value of a field = 'Yes'. I have built an event procedure in the detail section (on format) as follows:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Late = "Yes" Then
Me.Detail.Visible = True
Else
Me.Detail.Visible = False
End If
End Sub
But it suppresses all of the detail, not just the line(s) that should be suppressed. I even tried the "cancel = true" option but that has the same results.
Anyone had any luck with this?
I want to skip a detail line if the value of a field = 'Yes'. I have built an event procedure in the detail section (on format) as follows:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Late = "Yes" Then
Me.Detail.Visible = True
Else
Me.Detail.Visible = False
End If
End Sub
But it suppresses all of the detail, not just the line(s) that should be suppressed. I even tried the "cancel = true" option but that has the same results.
Anyone had any luck with this?