>>>>It seems like I remember this can be done - how can I have a negative number like -999.99 appear as 999.99 within a textbox? I thought this could be done or perhaps at least done with the negative number appearing as red.
>>>>
>>>>Thanks in advance....
>>>>
>>>>Mel
>>>
>>>ABS()
>>>and
>>>DynamicBackColor, DynamicForeColor
>>
>>
>>Ahhhh..... good idea... thanks....
>
>Still not quite sure you're doing the right thing. I tried to see a few possible cases where such a requirement was possible, and it all came down to "I wouldn't do it that way". If it was an accounting thing, then the negative amount should be on the other side - at least that's what the accountants taught me. If it's a negative debit, then it should be a credit. Unless it's a cancellation, in which case it must be negative. Showing it as positive is basically display of incorrect information.
>
>If it's just that your users can't grasp the concept of negative numbers, then again I wouldn't do it that way... I'd try to find a way away from them :).

It is for an accounting module, but not for a debit or credit column. Instead it is for a Budget column and the negative numbers are confusing in this column (in addition to the fact the users are use to it since 1988).

I fully agree on the Debit and Credit sides.