Validation rule required please

[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

 

[Ken Snell]

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

 

[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

.