473,898 Members | 3,971 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Formatting Currency Values

37 New Member
The currency values are displayed in format of the regional settings specified in the computer of the user. I would like to display all the currency values in dollar format irrespective of the regional settings. i tried formatting the currency columns as $#.##0,00;($#.# #0,00) but it still shows values in regional formats.
Is there a way to specify an application specific setting.
Jan 13 '10 #1
18 8178
MMcCarthy
14,534 Recognized Expert Moderator MVP
As far as I'm aware you can only set the custom format with the full stop as the decimal point and the comma as the thousand separator as follows:

$#,##0.00
Jan 13 '10 #2
NeoPa
32,584 Recognized Expert Moderator MVP
Exactly where and how did you try setting this currency format?

Everything I tried showed the values in dollars. My settings are set in standard British format with the £ (GBP) as the currency symbol.

PS. Though many European countries use the format you show (. & , reversed from the way used in Britain & America), this would be unusual for a display of dollars (I suppose it may be what they use in those countries when showing Dollars. I'm not really sure). I tested and I found my PC settings determined how each character is interpreted - regardless of where you put it in a format string. This doesn't look promising I'm afraid.
Jan 13 '10 #3
maxpirate
37 New Member
The format i specified has been set for all currencies in the tables.
When i view the data in table it show as dollars only but when i view the data in my reports the charts are taking up regional setting currency symbol which is GBP.
Jan 15 '10 #4
TheSmileyCoder
2,322 Recognized Expert Moderator Top Contributor
If the reports were made before you added the formatting to the table, they wont "inherit" the format value. You can manually assign it in the report, by looking at the textbox's format property.
Jan 15 '10 #5
maxpirate
37 New Member
that also has $#.##0,00;($#.# #0,00) set as its format
Jan 15 '10 #6
NeoPa
32,584 Recognized Expert Moderator MVP
I'm afraid I'm unable to reproduce what you describe Max. Even in a report. It always shows as dollars for me.
Jan 17 '10 #7
maxpirate
37 New Member
Do you think i need to code and set field format as $#.##0,00;($#.# #0,00) on form load
Jan 18 '10 #8
TheSmileyCoder
2,322 Recognized Expert Moderator Top Contributor
As far as I know, if you have set it correctly it should work.

If its still not working, then maybe you made a typo?

Is there any code attached to the field?
Jan 18 '10 #9
maxpirate
37 New Member
What is happening is there is pivot chart that has a query as a source. when i formatted the currency fields in the query to be displayed as dollars. after that when i saw the query result it is as expected.
When i see it on the pivot chart view inside a form its taking the regional setting format.
when i view the same as datasheet the values are formatted as $$$ as expected
Jan 18 '10 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

7
745
by: Chad Z. Hower aka Kudzu | last post by:
I have a typed dataset that is on a WinForm and I have labels that have their text properties bound to fields in a data table. The values are of type decimal. When I dispaly them in the label, I want to add a currency symbol and also insert comma's for thousands separators. Is there anyway to specify the formatting for a label or a field without breaking the databinding and doing it manually? Or can I specify the databinding in codde and...
16
25904
by: Douglas | last post by:
Gday, How would I format a number so that: TheValue = 32500 Displays in the TextBox as: $32,500.00
6
1344
by: Brad | last post by:
I guess I still have not grasped the logic of formatting a simple label or text box. Why would the following not work? I need the resulting label to display currency. lblAmtDue.Text = CInt(txtEntries.Text) * 1.5 lblAmtDue.Text.Format("$#,##0.00")
4
2036
by: Mitchell Vincent | last post by:
How is everyone formatting currency with VB.NET? Before I was calling the API function for it, which took the currency symbol from the Windows settings. I've found this to be limited when working with European countries where business in conducted in several different currencies. Are you guys just storing a currency symbol and formatting the number accordingly? What about the comma and decimal switch that some locales use? I hope .NET...
2
1977
by: Mitchell Vincent | last post by:
I have a bunch of text boxes and labels that hold currency values. I need some formatting on them, but since they are databound to a set, I'm confused as to how to do that. Do labels and text boxes have some kind of format string that can auto-apply a format to what ever data is entered? Is it possible to create a callback-type function that allows me to specify the formatting (for different currency symbols, etc). Dealing with multiple...
14
4388
by: Scott M. | last post by:
Ok, this is driving me nuts... I am using VS.NET 2003 and trying to take an item out of a row in a loosely-typed dataset and place it in a label as a currency. As it is now, I am getting my unformatted data values (as decimals) just fine, so I know there's not a problem with the data retrieval, just the formatting. I have read that this would work: lblPrice.Text = prodRow.ToString("C");
1
1330
by: scoarescoare | last post by:
I am running into a problem that I cannot seem to solve. I'm using ADO.NET 2.0 with vb 2005. I have a dataset as a datasource that selects all of the Shoe_Types from a Shoe_Type table. I am creating the data set and doing all of the data binding at runtime. I then bind each label at run time by doing: Me.lblShoeTypePrice.DataBindings.Add("text", Shoe_Type_DataTable, "Shoe_Price") I'm not exactly sure how I should go about...
1
1158
by: jereesh | last post by:
Hi, I need to display formatted currency values in the My UI currency fields. I would like to know how to do currency formating in javascript . ie when I pass the value and the currency code it should display the formatted currency in the field with currency symbol. the Code will be like USD, EURO etc. but when it get displayed it should display the curresponding sysmbol can any body help me in this Regard Regards
9
2329
by: john coltrane | last post by:
Is there way to create a formatted string in a similar that is similar to sprintf? The same for printing, printf? C,D,E,F,G,N,X for currency, decimal, exponential, fixed, general, numerical, and hex but these do not seem to allow for specifying the number of decimals, left/right placement, or string formatting. Thanks
0
9842
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10859
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10954
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
8036
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7191
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5882
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6078
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4708
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3308
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.