>>>>A numeric textbox will always show a - (minus sign) before a negative number. However, I would like to explicitly show a + (plus sign) when the number is positive, and neither when it is zero.
>>>
>>>
>>>Check TRANSFORM() it will give you (CR) or (DB) for Credit or Debit depending.
>>
>>Thanks for the idea, but it's not a currency field, it's a numeric variance, so CR and DB wouldn't work in this case.
>
>TRANSFORM() Can be a numeric field it does not need to be currency.
I understand... however, the field does not represent a currency figure, it actually represents a variance in square kilometers, so the CR/DB would not be applicable here.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up