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.