validate rule

[mike]

Hi all,

I'm trying to use the validation rule for one of my
textboxes. In the textbox property, validate Rule, I used
this expression: IsNumeric([textbox1]). I'm just trying to
make the user to enter numbers only. But the problem is,
the text box keep prompting with error. Either if I enter
numbers or alpha, it just saying it is incorrect.

Any suggestion??

Thanks,

mike

 

[Dan]

Good Afternoon!

You are on the right track. Try the expression as follows:

IsNumeric([textbox1])=True

Good Luck.

 

[GVaught]

Also, if the numbers entered are always the same length you can set masking
to 000000 or the number of zero's that are required for your entry. zero's
will restrict the values to be numeric, 9 makes them optional.