Text box divide by zero

[le888]

Hi,

I have a text box which contains a formula. When the text box is divided by zero, it appears #ERROR in the text box. I would like it to be invisible when it divided by zero and to be visible when it has a number.

Any ideas?

Thanks,

Le

 

[boblarson]

=IIf([YourFieldNameHere]=0,"",YourFormulaWouldGoHere)

 

[Luddite Lad]

Perhaps this new theory would help

 

[boblarson]

ROFL