Validation Problem

[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

 

[Marshall Barton]

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.

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]*"