Hide a GroupHeader

[arthurmq]

Hi, I’m trying to use the following code in a report to hide the ‘GroupHeader0’ whenever ‘Text1’ is blank, but is not working. When I typed ‘If Me![Text1] .Text’ in vb, after the dot the “Text” option is not under the drop down list as an option. Do I need to set different property?
Any help will be greatly appreciated
Thank you


Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
If Me![Text1] .Text = "" Then
Me.GroupHeader0.Visible = False
Else
Me.GroupHeader0.Visible = True
End If
End Sub

 

[jdowski]

Try one of these 2 ways:

if me![text1] = "" then.....
or
if isnull(me!text1)=true then......

Hope this helps !!

Joe in Oxford, CT. USA.

Hi, I’m trying to use the following code in a report to hide the ‘GroupHeader0’ whenever ‘Text1’ is blank, but is not working. When I typed ‘If Me![Text1] .Text’ in vb, after the dot the “Text” option is not under the drop down list as an option. Do I need to set different property?
Any help will be greatly appreciated
Thank you


Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
If Me![Text1] .Text = "" Then
Me.GroupHeader0.Visible = False
Else
Me.GroupHeader0.Visible = True
End If
End Sub

 

[arthurmq]

The second code worked better, Thank you!