validate rule

  • Thread starter Thread starter mike
  • Start date Start date
M

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
 
Good Afternoon!

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

IsNumeric([textbox1])=True

Good Luck.
 
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.
 
Back
Top