I need help

[anonymous]

[Originally posted by Kristine Wilton]

On a form that I'm working on, you enter a number of hours in the text box and it returs a commision.ÿ what I need is to not let the employee enter any number over 160.ÿ Any help that you could give me would be appreciated

[anonymous]

[Originally posted by Marc Cramer]

Hello...

try
if CINT(VAL(textbox.text))>160 then
msgbox "Only numbers under 161 Allowed"
textbox.setfocus
end if

[anonymous]

[Originally posted by ali]

use IsNumeric( val ) to check for valid numbers
then convert it into number and check the value

[anonymous]

[Originally posted by Jehanzeb Navid]

hi! i think u can use the max length code to make the numbers up to 160.
jayzee