Hello,
I have a report in which I am trying to hide some rows. See the two attached printscreens. The first printscreen shows the rows (highlighted by yellow box) that I am trying to hide if they have a null value for the "Group of Division Subgroup1" field. I have used the coding below. The second printscreen shows that it works for all but the first group (Strategic Reserves). This grouping still shows the row that should be hidden and inserts a #Name? error. Can anyone help with this?
Private Sub GroupHeader2_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(Me.Group_Of_Division_Subgroup1) Then
Cancel = True
End If
End Sub