I saw the question on how to not display null fields in the detail sections of the report and tried to apply this same code to Group Header Section. I am printing an item list by Class and Sub Class. Not all items have a subclass but the header displays Class and then a blank text box for the subclass. The following code will not work... any suggestions? IMUS15 is the subclass field in my table.
Debug shows that the field is blank.
Private Sub GroupHeader2_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(Me.IMUS15) Then
Me.GroupHeader2.Visible = False
Else
Me.GroupHeader2.Visible = True
End If
Debug shows that the field is blank.
Private Sub GroupHeader2_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(Me.IMUS15) Then
Me.GroupHeader2.Visible = False
Else
Me.GroupHeader2.Visible = True
End If