>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,"@(###,###.##")
By the way, I just realized that you said the option does not exist for the reports, this is not quite true, you can set the format tab of the textbox's properties: put the #s in the format expression and check the (negative) checkbox of the format options
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges