I want to hide a feild on an Ac

[Mahatmt]

I want to hide a feild on an Access 2000 Report. I have done this before, but for som reason can not get it to work.

I have a hidden field on the report. if that field is NULL i want to hide other field, but it does not seem to work even though the debugger steps through it and appears to work - the field are still shown.

Here is ny code:

If Me.HiddenExpText = "" Or IsNull(Me.HiddenExpText) Then
Me.ExpText.Visible = False
Else
Me.ExpText.Visible = True
End If


Thanks.

 

[GingerR]

where is your code? in the DETAIL FORMAT event?

you can also add

... or len(me.HiddenExpText)=0...

sort of like ="" just another way to catch if there's nothing in it