>I need a control that displays negative dollar amounts in red and with parenthesis instead of a minus sign. I will use it for data entry as well as inside grid controls - the latter for display only, not data entry.
>
>I've been able to use an assign method on the Value property to change the forecolor if the value is negative. (It got a little tricky with using the control in a grid, but I've gotten it to work.) What I'm having trouble with is removing the negative sign and using parenthesis instead. I haven't found any format code or input mask that will do this. Any ideas?
To display Fore color in red you can use DynamicForeColor property of the grid:
thisform.Grid1.ColumnXXX.DynamicForeColor = [IIF(GridRecordSource.ColumnWithAmmount < 0, RGB(255,0,0), RGB(0,0,0))
Now I'm thinking how to put [(] and [)] over the negative values.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.