CODEWITHSUNDEEP
databasevalidationms-accessalphanumeric
a_shakespeare
a_shakespeare

Reputation: 1

Microsoft access validation

I need to only allow only alphanumeric characters to be entered into a field. The data type is 'Short Text'.

What is the 'Validation Rule' using the expression builder?

Upvotes: 0

Views: 134

Answers (1)

Andre
Andre

Reputation: 27634

You can find lots of useful examples for validation rules here:
http://allenbrowne.com/ValidationRule.html

In your case -

Digits and letters only

Is Null OR Not Like "*[!((a-z) or (0-9))]*"

Accepts A to Z and 0 to 9, but no punctuation or other characters.

Upvotes: 1

Related Questions