Controlling Decimal Places

[Tarbuza]

I want to prompt an invalid number onBlur of my Amount field if the user types in 500.438 (valid number is 500.43). I don't want to chop myself but prompt the user that it is invalid to type more than two decimal places.

Any help would be greatly appreciated. Thanks.

 

[jebry]

Hi!

If you want to force the user to put in only two decimals you can use the following code in the before update event procedure of the text box:

If CDbl(YourText.Text)*100 Mod 10 <> 0 Then
Call MsgBox(&quot;You may only enter two demicals&quot
Cancel = -1
End If

hth
Jeff Bridgham
bridgham@purdue.edu