No $ for Currency fields

[Melissa]

I have several fields in my database specified as Currency data type. Is there a
way globally to set these fields not to display the dollar sign?

Thanks!

Melissa

[Wayne Morgan]

You may try removing the symbol from your local settings in Control Panel.
However, a better option, depending on your version, may be to use a Number
datatype and in the bottom where it says Field Size, choose Decimal. Another
option may be to use the Format option to remove it. This will still give
you the Currency datatype and its precision, but without the character.

--
Wayne Morgan
MS Access MVP
"Melissa" <mw*****@earthl ink.net> wrote in message
news:sg******** ********@newsre ad2.news.atl.ea rthlink.net...

I have several fields in my database specified as Currency data type. Is there a way globally to set these fields not to display the dollar sign?

Thanks!

Melissa

[fredg]

Melissa wrote:

I have several fields in my database specified as Currency data type. Is there a
way globally to set these fields not to display the dollar sign?

Thanks!

Melissa

The Currency Datatype is different than Currency Formatting.
Formatting affects only how the field is displayed.
Retain the Field Datatype as Currency, but set the format to Fixed with
2 decimals,
or use

#,###.00;-#,###.00;0.00

in the format field if you wish the comma as a thousands separator and
0.00 if the field is Zero.
See Access Help regarding
Format + Currency and Number Datatypes
for additional possibilities.
--
Fred
Please reply only to this newsgroup.
I do not respond to personal e-mail.

[Trevor Best]

On Wed, 17 Dec 2003 20:57:24 GMT in comp.databases. ms-access, "Wayne
Morgan" <co************ *************** @hotmail.com> wrote:

You may try removing the symbol from your local settings in Control Panel.
However, a better option, depending on your version, may be to use a Number
datatype and in the bottom where it says Field Size, choose Decimal. Another
option may be to use the Format option to remove it. This will still give
you the Currency datatype and its precision, but without the character.

<rant>

IMHO there should be a global option to turn this off, it's a right
royal PITA to have it displayed as default, particularly as every app
I've ever written in Access that handles money is multi currency.
When exporting to other formats I have to resort to cdbl() or
something in a query to stop the currency symbol from being exported
also. As far as I'm concerned when exporting to another format there
should be no formatting of any kind unless explicitly specified.

</rant>

p.s. sorry for tagging on your post Wayne, my rant isn't aimed at you.

--
A)bort, R)etry, I)nfluence with large hammer.