Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to NON-display a textbox on a Report Group Header 1

Status
Not open for further replies.

lreedy

Programmer
Jan 4, 2001
8
0
0
US
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

 
Yes, I tried the can shrink,.....No luck.
Thanks,
Lisa
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top