Words in Number box

[gumbi17]

I have been trying many different ways to get a box that shows interest in a property to give a statement if it equals "0". The interest shows to the 8 decimal point and is fixed. So numbers could range from .00001245 to .99999999, but what I need to have it do is when it is 0.00000000 to have it use Varies instead of showing the number. I have tried an IIF statement and it didn't work for me, any other ideas?

 

[Galaxiom]

In the Format Property of the textbox:

#;#;"yourtext"

 

[gumbi17]

Worked great, thanks!