VB6: formatting textbox (#,###.##) in every LostFocus

[montzter]

Hi evryone,

I'm having trouble in formatting the inputed data in the text box so that everytime user lost focus it will adjust its value to contain the format (#,####.##). ie user will input 1111.1 it will immediately be converted to 1,111.10 as its value.

I've tried using this code in every lost focus:
textbox.text = round(val(textbox.text)), 2)

but the problem with this is I am not getting the comma and if the user enters an exact integer value (means without decimal) it will remain as is.... I've also tried changing the text box property data format to number and checked the box to separate thousands in coma, but its not working.

Can anybody help me.

Thanks

[Dököll]

... I'm having trouble in formatting the inputed data in the text box ...

Go to Projects + Components + MS Masked Edit Control, see what that does...

I should perhaps mention you may need to add maskedtextboxes in place of the ones you now have. Perhaps there is another way of achieving this through regular textboxes, but I would go with masked ones :-)

In a bit!

[Killer42]

A few things come to mind...

• Try using "0" rather than "#" in the format to force a digit to be included. For example, I think Format(number, "#,###.00") might work.
• The code you posted doesn't actually use the Format() function.
• The problem with this sort of approach is that you will probably need to strip out the comma(s) in the GotFocus event, and trust the user not to type them. I don't think the Val() function accepts them. You could also create your own function which combines the comma-stripping and string->number conversion. So instead of just using Val() you'd use something like TextBox.Text = StringToNumber(TextBox.Text) which would handle removing commas and converting to a number.
• The Round() function rounds a number up or down to the specified number of places. It has nothing to do with formatting the number for display. If you "round" 5.00 to two places, you still have 5.00, which is exactly the same number as 5.0, or 5.000000000.
• I believe the DataFormat property only applies to displaying a database field in the textbox. Are you doing this?
• I'm curious - where was the "separate thousands in coma" checkbox that you checked? I'm not familiar with it.
• Have you considered using a Masked Edit control instead of a textbox? It gives you much better control over the format.

Well, I hope that is some help.

[montzter]

You guys do reply fast!!! I thought I can get the reply in a day or two!!!
anyway I have tried the first reply and I will go with it. Value of the maskedbox.text remains unchanged even if there were already commas being entered. this is cool compnent..


Thanks for pointing me to the right direction.

[montzter]

A few things come to mind...

Wow you have a lot of ideas but sound too complicated for me. I go with your last bullet. Actually I am using a database. There's no problem with the data in the database, it's just that the user wants it in this format to be displayed. So got a problem with the textbox.

Thanks again for the help.

[Killer42]

Glad we could help. :)

As for the quick response, you were just lucky to catch a couple of us at the right time. It can sometimes take quite a bit longer.