access - currency

[dema]

Hello-

Can anyone tell me how I can have negative currency appear
with a minus sign rather than parenthethis?

Thanks

 

[SA]

Dema:

The "default" format that you see currently, is determined by the computer'
regional settings for currency display, you can always change those for a
global system change. To force a format other than what's in the Regional
Settings, use the Format function as in =Format([MyField],"$#,##0.00")
Which will not use parenthesis.

 

[Mercedes Howard]

Hey dema,
If I were you I would go to format and change it
around. This would then allow you to display neg.
currencies.
Good Luck,
Mercedes