how to change the currency symbol in access

[Guest]

How do i change the currency symbol in microsoft access 2003? Right now mine
is in £ and i want it to be change to $. Anyone know how to go about doing
this?

 

[Mark]

AFAIK, the currency data type follows the regional settings of Windows; you
should check your Control Panel settings. There's also a Euro data type,
which will always show the Euro Currency symbol regardless of regional
settings.

 

[Troy]

Mark is correct. Windows regional settings control the "Currency" format
displayed.

If you want to display the $ sign at all times (regardless of Windows
settings), just use a custom format instead of the built in Currency format:

$#,##0.00

--
Troy

Troy Munford
Development Operations Manager
FMS, Inc.
www.fmsinc.com


"Mark" <no_email> wrote in message
AFAIK, the currency data type follows the regional settings of Windows; you
should check your Control Panel settings. There's also a Euro data type,
which will always show the Euro Currency symbol regardless of regional
settings.