number format in textbox

Question

0.00/5 (No votes)

See more:

we have some requirement like:
Default values should be displayed as 0.00 in the textbox.
And here some criteria like before decimal, it should accept <=13 digits and after decimal it should accept only 2 digits and "." should be readonly.User should not able to remove "."
If user enter the value like "1234567890123.12" then i want to display the format "1,234,567,890,123.12".
Ex:12345.56
output:12,345.56

Posted 8-Jun-10 2:07am

NareshNama

Updated 8-Jun-10 2:13am

Tom Deketelaere

v2

Add a Solution

Comments

Tom Deketelaere 8-Jun-10 8:14am

And your question is?
You'll have to write a custom control for this (isn't that hard to do)
You don't expect us to just write if for you now do you, don't you want to learn something?
Show us what you have tried and where you are stuck (specific piece of code if possible) and we'll help but we won't just write this for you.

3 solutions

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)

OriginalGriff · Answer 1 · 2010-06-08T02:47:00

Solution 1

Have a look at Masked Text Box[^] it should do what you want, but you may have to fiddle with the mask a bit...

Posted 8-Jun-10 2:47am

OriginalGriff

Comments

Tom Deketelaere 8-Jun-10 9:01am

It won't do everything he want's but it will get close.

NareshNama 9-Jun-10 7:44am

masked text box is a fixed length.Through this is not possible.
Ex:For 13 digits value,if i enter only 10 digits it will display like
msked text box = 1234567890___.56(in design time)

Henry Minute · Answer 2 · 2010-06-08T03:27:00

Solution 2

As Tom has already suggested a Custom Control would probably be the most efficient way to meet your requirements.

To help you in the design you should research String.Format() and FormatStrings.

Posted 8-Jun-10 3:27am

Henry Minute

shukla dhaval · Answer 3 · 2010-06-08T19:50:00

You can set MaskEdit Control to meet your requirement and after entering value you can use format function to display with your desire output.

If you want to your textbox should accept either 13 or <13 character then you must use format function to satisfy your requirement.

User textbox validated event and check it.

Txt_validated()
if txt.text.length < 13 then
txt.text = format(txt.text,"#############.##")
end if
end sub

For getting details that only one decimal point should allowed and after that only 2 digits can be allowed for that you have to use key press event and with instr function you can check whether decimal point is there or not.