Extract part numbers

[RichieP]

I've search the forum with no luck.

I know you can search for part words by using one of these types of code:


Left(stringexpr,n)
Right(stringexpr,n)
Mid(stringexpr,start,n)



How do I do the same with numbers? I want to extract every thing past a decimal point.
For example, I have 5.912 in a box on a form and I want an unbound textbox to extract the .912 and times it by 12.

Any ideas?

Cheers for you time

 

[Mile-O]

As the controlsource of your unbound textbox:

= Mid(CStr(txtYourNumber), InStr(1, CStr(txtYourNumber), ".") + 1) * 12


where txtYourNumber is the original value to calculate upon.

 

[RichieP]

Thanks, did the trick.