change currency symbol

[enrico via AccessMonster.com]

my data property of my amount field is currency. when i query the sum of the
amount a dollar sign will represent the whole sum. can we change the dollar
sign to any currency symbol or if not just omit it.

 

[fredg]

my data property of my amount field is currency. when i query the sum of the
amount a dollar sign will represent the whole sum. can we change the dollar
sign to any currency symbol or if not just omit it.

The currency format gets it's symbol from whatever currency has been
set up in the computer's Windows regional settings.

You can omit it if you wish.
Set the control's Format property to:
#,##0.00

If you would like to display a different symbol, such as perhaps the
Euro, you could set the Format property to:
¤#,##0.00
To get the Euro symbol press Alt + 0128 (using the Number keypad).

The British Pound (£) is Alt + 0163
£#,##0.00