Changing negative currency values from brackets to " - "

[michaeljohannes]

I have an issue with the format of the data in a form.

I have a form I'm using to calculate totals (in the currency format). If the difference is negative, the negative result in the control is displayed with brackets instead of something like "-$20,000"

For example:

me.control3 (the text box showing the difference)
me.control1 (say $100.00 for example)
me.control2 (say $200.00 for example)


me.control3 = me.control1 - me.control2

would display

"($100)" in the text box (me.control3)

as opposed to

"-$100" which is what I prefer


The reason this is becoming an issue is because I want to add (later in the form) what might be a negative value in a control plus a positive value in another control. When execute this command (to add the two) Access, is treating both values as if they are POSITIVE, giving me a bogus calculation.


Any thoughts, or help? I would be most appreciative.

Thanks,
Mike









would show

 

[gemma-the-husky]

try something like changing the fields format property to -##0.00

 

[michaeljohannes]

Cheers, thanks!