Hide when field is 0

[alvin Kuiper]

Hi
I have a field in my DB if this Field are = 0
then i dont want to see this field on my report
Is there a way to do this?

Alvin

 

[alvin Kuiper]

Thanks

Alvin


"Rick Brandt" skrev:

Do you just want to hide the contents of the TextBox or do you also need to hide
the TextBox itself and/or any label associated with it?

To just not see the actual zeros use a ControlSource of...

=IIf(FieldName=0, "", FieldName)

To hide anything else you need to use code in the Format event of the relevant
report section.

If Me!FieldName = 0 Then
Me!SomeControl.Visible = False
Me!SomeOtherControl.Visible = False
Else
Me!SomeControl.Visible = True
Me!SomeOtherControl.Visible = True
End If