O oscar Jan 5, 2004 #1 What is the code to validate a text field to be alpha only? Any sites with examples of validation rules and field formatting?
What is the code to validate a text field to be alpha only? Any sites with examples of validation rules and field formatting?
M Michel Walsh Jan 20, 2004 #2 Hi, NOT LIKE '*[0123456789]*' include all the characters you do not want to see (here, I assumed just digits were forbidden). Hoping it may help, Vanderghast, Access MVP
Hi, NOT LIKE '*[0123456789]*' include all the characters you do not want to see (here, I assumed just digits were forbidden). Hoping it may help, Vanderghast, Access MVP
