Command to omit first number not the best choice?

Hi ,

I recently has some code whereby a TextBox would display a number without the first digit. So, 3.456 would be displayed as .456 which allowed the textBox to make a certain calculation.
However, sometimes the number 12.214 would be displayed and of course I need .214 but the TextBox is displaying 2.214. So I need code that will display any number including and after the decimal point?

Can anyone help as to how this line can be adapted?

Please Login or Register  to view this content.

Many Thanks

Thanks, I'll give it a go Cheers

Got a Syntax error?

There's a misplaced bracket, but (as in the code in your image), you should use the VAL() function to ensure you are working with real values

Please Login or Register  to view this content.

I've put this but got crazy values?

Old code gives me 0.569 (which is correct) but the code:

Please Login or Register  to view this content.

gives me -36.431?

Ideally, I'd like the code to take a number from the decimal point onwards. That was it won't matter how many digits are before the decimal point because the code will ignore them all.For example, the figure 123.456
will be .456, if the figure is 12.456 it will still be .456 and if the figure is 3.456 it will still be .456.

??

Did you note the comment about "whatever Textbox number it is"???

Sorry, it does work fine, I missed the last Text Box:

Please Login or Register  to view this content.

Thank you very much ;-)