Field Visibility

[cbrsix]

I have a report that contains text boxes with dates in them, not all fields have dates. I want the fields that don't have anything in them to be hidden. Below is the code that I have tried but it is not working completely.

Private Sub Report_Load()
If IsNull(Me.Alabama) Then
Me.Alabama.Visible = False
Else
Me.Alabama.Visible = True
End If
End Sub

This successfully hides the textbox when there is nothing in it but when there is a date in there, it still hides it (when it should be visible).

Any ideas?

Thanks.

[John_G]

If the date is in some records, but not others, then you have your code in the wrong place; put it in the On Format event of the Detail section.

You code is fine - but you could replace the If-then-else with one line: Me.Alabama.Visible = not IsNull(Me.Alabama)

HTH

John

[cbrsix]

Thank you, that worked. I have a follow up question now...if that line is blank, because of the above code, will that blank line continue to be there or will it go away if I set the property to can shrink?

[cbrsix]

Nevermind, I figured it out. That is what you would do.