I know this should be easy, but can’t get it to work. I have a field that is displaying a negative number and what I want to do is, if that field is negative…(hide it) and dispaly a gif I have (Overdue.gif). Any ideas?
Subject: Negative Number In A Field - Show Different Value
Place the overdue gif on the next line of the form
In the hide-when formula of the field/line the field is on, hide when fidlvalue<0
On the overdue gif, hide when field value>=0
Subject: RE: Negative Number In A Field - Show Different Value
Dang, that is so obvious! Thanks Mike ![]()
Subject: RE: Negative Number In A Field - Show Different Value
But beware of empty number fields. They are actually text (empty string). Depending on how your documents are created you may or may not have to take care of that. @ToNumber should work in this case to convert “” to 0 and leave numbers alone.