access - currency

D

dema

Hello-

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

Thanks
 
S

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.
 
M

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
 
Top