Hi All,

I would like to have code run on a report and pull the label off if the field is blank. I have code in my form that is :
If IsNull(Me.Auditor2nd) Then
Me.Auditor2nd.Visible = False
Else
Me.Auditor2nd.Visible = True
End If

How can i incorperate code to say if if isnull(me.auditor2nd) the me.labelXYZ.visible = false?

I think i am missing something. Thank you.

How about
If IsNull(Me.Auditor2nd) Then
Me.Auditor2nd.Visible = False
Me.labelxyz.Visible = False
Else
Me.Auditor2nd.Visible = True
Me.labelxyz.Visible = True
End If

I would do ...
Me.Auditor2nd.Visible = Not IsNull(Me.Auditor2nd)
Me.labelxyz.Visible = Not IsNull(Me.Auditor2nd)