>Hi,
>
>A client just asked me to display negative amounts in textboxes with the bracket, like (100.00) intead of -100.00. I did that for the reports, but in the textbox I did not find a formatting option for that. So I need to transform with "@(". But how can I combine with thousand seperator?
>
>
TRANSFORM(-1000000.00,"@(###,###.##")
For instance:
ln=-1000000.00
?IIF(ln<0,"(","")+ ALLTRIM(TRANSFORM(abs(ln), '$$,$$$,$$$,$$$.99'))+ IIF(ln<0,")","")
Good Luck