Text box to allow 2 decimal

[fabian_76]

Hi Folks,

I am trying to limit my Textbox to these numbers 22.45, 10.45 etc. This is my code. It is giving me the 2 decimals por only allowing me to put 1 number before the dot e.g. 2.45, 1.45 etc. Any idea?

TextBox2.Value = Format(TextBox2.Value, "##.##")

[6StringJazzer]

That format will retain any number of digits to the left of the dot. Give a specific example of a number you enter and the result you get.

You might also try this:

Please Login or Register  to view this content.

[fabian_76]

Thank you. I want to enter 22.45 but when entering the 22 it only allows me to put one "2" after this the dot comes up and it lets me to put the decimals "45". As a result I only get 2.45 instead of the 22.45

[6StringJazzer]

Ah, incomplete information. Is your line of code in Sub TextBox2_Change? If so, then this is the wrong approach for what you want to do.

There is no need to force this format as you go. Move your line of code to the place in your code where you actually use the value, such as the click of a button. This gives the user the chance to enter the entire number before you reformat it.

[fabian_76]

Thank you! It worked.