av8tordude
01-09-2011, 01:20 PM
Dim v As String
v = Replace(Me.MPct, "%", "")
Me.MPct = Val(v) & "%"
I have this code that allows the user to enter percent number. I would like to prevent the user from enter anything greater than 100%.
i.e. if the user types 150% and exits from the textbox, display the amount as 100%. if the user enters 50% and exits from the textbox, then it displays 50%.
thank you for your help
v = Replace(Me.MPct, "%", "")
Me.MPct = Val(v) & "%"
I have this code that allows the user to enter percent number. I would like to prevent the user from enter anything greater than 100%.
i.e. if the user types 150% and exits from the textbox, display the amount as 100%. if the user enters 50% and exits from the textbox, then it displays 50%.
thank you for your help