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!

Group Totals Non display on blank

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?

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

 
Try putting a breakpoint in your code and using a watch to check what the value of Me.IMUS15 is when the statement

If IsNull(Me.IMUS15) Then

is executed.

Do you get an error when you run the report or does it just show all the empty subclass headers?
Mike Rohde
rohdem@marshallengines.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top