Wednesday, March 27, 2013

Validation Rules for Fields and Controls in Microsoft Access

Often, we tend to use simple or no validation rules in Microsoft Access fields. I just wanted to block punctuation in content because I wanted to use the content as a a way of generating query column names (data driven architecture). Scrambled for the web and here's the official article with examples.

To allow digits and numbers but not punctuation, try:
Is Null OR Not Like "*[!((a-z) or (0-9))]*"