Validation Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear All,

I am using a validation rule ^[0-9]*$ in my TextBox on Access form which
allows only Numbers to be entered in the TextBox. How ever it doesnt seem to
be working.And I am geting "Please enter Numbers only" validation text every
time I enter anything in the textbox.

Any idea whats going on.

cheers,
Sam Solomon
 
Sam said:
I am using a validation rule ^[0-9]*$ in my TextBox on Access form which
allows only Numbers to be entered in the TextBox. How ever it doesnt seem to
be working.And I am geting "Please enter Numbers only" validation text every
time I enter anything in the textbox.
Click to expand...


That looks like a Regular Expression, which Access (and most
MS programs) do not understand. Check Help for Wildcard
Characters to see what you can use.

I think you can use this to check for only digits:

Not Like "*[!0-9]*"
 
Back
Top