Changing a text box depending if the total is (-)

[zxmax]

Greeting all
i have a report showing an invoice,

on the last line of the invoice i have the total, its showing "balance Due" and the amount $ beside it.

Now what i want to do is, if the balance comes up with a (-) value, i want to change the "balance Due" message to " Balance"

so basically , if the total comes with minus (-) then i would get a message, and if the total is plus (+) then it would show a different Message,

is that even possible to change the text box ?

thanx for any thoughts

 

[pbaldy]

How about

=IIF(AmountField > 0, "Balance Due", "Balance")

 

[zxmax]

Works great, Thanks,