thousand separator on keypress event

Question

2.00/5 (2 votes)

See more:

hi,

i have a form to get customer informations and i must have a number value in a textbox. my problem is getting it formatted as decimal on key press according to culture. forexample when i typed 100025 into a textbox i want it to format as 1.000,25 while i am writing.

how can i do this?

thank you?

Posted 11-Apr-13 9:35am

Halit YILMAZ

Add a Solution

Comments

Sergey Alexandrovich Kryukov 11-Apr-13 15:45pm

Did you simply try to read documentation?
—SA

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sergey Alexandrovich Kryukov · Answer 1 · 2013-04-11T09:44:00

Solution 1

It could be something like

C#

const string numericFormat = "###,###,###,###,###,###,###"; // make it long enough to fit maximum and minimum decimal of the range you need
// if this string is longer then needed, it won't harm

//...

decimal myValue = //...
myTextBox.Text = myValue.ToString(numericFormat);

For further detail, please see:
http://msdn.microsoft.com/en-us/library/system.decimal.aspx[^],
http://msdn.microsoft.com/en-us/library/fzeeb5cd.aspx[^],
http://msdn.microsoft.com/en-us/library/dwhawy9k.aspx[^],
http://msdn.microsoft.com/en-us/library/0c899ak8.aspx[^].

[EDIT]

This format is already globalized. Even though the format notation of ',' is used, in formatted string it will appear as ',' or '.', depending on current thread culture.

I appreciate Matt for a fix and a useful note on globalization, please see the comments below.

—SA

Posted 11-Apr-13 9:44am

Sergey Alexandrovich Kryukov

Updated 11-Apr-13 12:58pm

v7

Comments

Sergey Alexandrovich Kryukov 11-Apr-13 15:49pm

Matt, thank you very much for the fix. I removed comments to avoid confusion...
—SA

CPallini 11-Apr-13 15:50pm

5.

Sergey Alexandrovich Kryukov 11-Apr-13 15:55pm

Thank you, Carlo.
—SA

Maciej Los 11-Apr-13 16:11pm

Now (after EDIT) my 5!
I'm happy that my answer point you to add information about globalization ;)

One more time, thank you, Sergey!

Sergey Alexandrovich Kryukov 11-Apr-13 17:19pm

Thank you, Maciej.
—SA

Matt T Heffron 11-Apr-13 18:06pm

Actually, the Custom Format String in the .ToString() is already "smart enough" to use the correct localized thousands separator. using the ',' (comma) in the format string is quite correct. The localized thousands separator will actually be used in the resulting string.
http://msdn.microsoft.com/en-us/library/6F74FD32-6C6B-48ED-8241-3C2B86DEA5F4(v=vs.100,d=lightweight).aspx

Sergey Alexandrovich Kryukov 11-Apr-13 18:10pm

Really? I never tried...
Oh, I guess you are right. The thing is: documentation only says that ',' is the format for group separator, it does not really say that ',' will actually appear in the formatted string.

Thank you so much for this clarification. I will remove this edit now.

—SA