>I'm working on that one...
>
:)
Well, if the parenthesis don't need to show while actually entering (or correcting) a number, it would be much easier. You can superimpose two textboxes...one that is for entry, one for display. On lostfocus() of the entry textbox, set the value of the display box (using the transform()), and put the display one back on top (or make the entry on not visible again).
Now don't come back and say it's in a grid...*grin*
>>Do they want the parenthesis to appear *while* they are in the textbox? If so, how would do they turn a negative number into a positive one?
>>
>>
>>>That's fine for display but, I have a numeric field bound to a textbox. The client wants negative numbers in parenthesis...
>>>
>>>>How's this?
>>>>
>>>>
>>>>x = -99.01
>>>>? transform(x, "@( 999999.99")
>>>>
>>>>
>>>>>How do you do this?
Steve Gibson