>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,"@(###,###.##")
Unfortunately, the format property of the textbox, which corresponds to the function codes that go between the @ and the space in the picture parameter of the transform() function, does not support all of them.
You can fake it by having the textbox.controlsource="transform(...)" when it doesn't have the focus, and switching to the real field when it does. That would mean setting a few properties in the .gotfocus() and .lostfocus(). Or maybe just .controlsource - haven't tried.