Validation rule required please

O

Omar Khawaja

Hi everyone,

I've forgotten what the validation rule is when you want
NO LETTERS in a field.

I remember it starts with:

NOT LIKE

then there's some '' but i've forgotten what the middle
bit is. i think there are some * in it too.

HELP!!!!
Thanks a lot
 
O

Omar Khawaja

thanks a lot Ken, much appreciated


-----Original Message-----
Not Like "*[!0-9]*"


--
Ken Snell
<MS ACCESS MVP>

Hi everyone,

I've forgotten what the validation rule is when you want
NO LETTERS in a field.

I remember it starts with:

NOT LIKE

then there's some '' but i've forgotten what the middle
bit is. i think there are some * in it too.

HELP!!!!
Thanks a lot
Click to expand...


.
Click to expand...
 
Top