>>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.
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