hide a calculated textbox if = "0"

[krberube]

I know I have seen this somewhere before but can't seem to find it now.
On a report, I have a calculated textbox -- =Sum(IIf([ServiceOrderStatus]="2",1,0))

If the sum = 0 I want to set the visible property to "false"

what would be the best way to so this?

thanks
Kevin

 

[Malcy]

Hi
Not sure if reports work the same way as forms (I think they do) but putting in something like

 if Me.txtbox = 0 then
Me.txtbox.visible = false"

You might need to put Me.txtbox.value = 0 and you might need inverted commas round the 0.
Hope this helps
Good luck