473,320 Members | 1,572 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

No $ for Currency fields

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
Nov 12 '05 #1
3 13292
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*****@earthlink.net> wrote in message
news:sg****************@newsread2.news.atl.earthli nk.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

Nov 12 '05 #2
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.
Nov 12 '05 #3
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.
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Brandon McCombs | last post by:
hello, I have an app that pops up a custom dialog box and one of the fields for user input is an account balance field. The data gets put into an Object and eventually into an instance of...
2
by: Micromanaged | last post by:
In my response.write line, I need to format a field to be a currency value. Is there a quick and dirty way to do it or is it an involved edit? Here is my code: Response.Write("<td>" &...
3
by: news.shaw.net | last post by:
I have a subform that contains a currency field. If I tab my way to the field, everything works as desired, a number can be entered, and when I leave the field it is rendered as a currency...
1
by: Tom Keane | last post by:
Hi, I need some helpings again! I have a query from one of my tables that gets a total amount of money and gets a percentage from it ie, the field I create in the query is invGSTAmount from a...
3
by: Dave Stone | last post by:
This question appeared years ago in the context of Acc2K and SQL Server 7, but no replies were posted. HOWEVER!! It still seems to be a problem with Acc XP and SQL Server 2000. Surely someone has a...
2
by: David Nunn | last post by:
Need to preface that I am not much of an Access type. Doing I have several tables that have currency fields, which I run queries against to compare the figures in both. The data is imported from...
1
by: Rob Richardson | last post by:
Greetings! I have a database created in MS Access that has some fields containing Currency data. Every time I try to use one of the OleDbDataReader's GetXXX() methods to read it, I get an...
15
Zwoker
by: Zwoker | last post by:
Hello everyone, I have an MS Access 2003 application that is distributed as an MDE. All the users around the Asia/Pacific region that use it are running Windows XP. Many of them have...
2
by: Ian | last post by:
I have an Access 2000 database written in the UK, this database has many fields set to Currency, I now want to move this database over to a user in the USA but my Currency fields still show the UK...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.