access - currency

  • Thread starter Thread starter dema
  • Start date Start date
D

dema

Hello-

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

Thanks
 
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.
 
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
 
Back
Top