change currency symbol

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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200907/1

On Fri, 03 Jul 2009 05:05:59 GMT, enrico via AccessMonster.com wrote:

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
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail