>>I see no sign in help that a Format of "(" does what you want, and in fact, I don't see a way to do it without converting the value with Transform or something like that. In a report, it's easy; there's a checkbox on the Format tab.
>>
>>Tamar
>
>
>understood.
>but it has to be when user inputs the value, not on the report
>so the user inputs -123 it will show (123)
You can probably add code to valid event of the textbox to change how it's displayed.
If it's not broken, fix it until it is.
My Blog 
