Visibility

[Guest]

Hello,

A question already asked but It did not help me. I am asking again !

In a report, I would like to hide some text box if the value of a control is
0.
I tried this without success:
In the format event of the header,

If IsNull(Me.sumofmvts) Then Me.Label13.Visible = False

I tried also
If (Me.sumofmvts)=0 then
Me.Label13.Visible = False
End If

Nothing happens if it is not bugging.
Can anybody help me ?

Thanks in advance
Serge

 

[Duane Hookom]

You shouldn't need any code. Just set the format property to something like:
$#,##0.00[Green];($#,##0.00)[Red];"";""

The above expression is modified from a Help example after searching on
Format Numeric.