Access 2016: Short-text validation rules

Question

I'm trying to make a full name field for my Access 2016 database field, and would want to restrict the characters accepted to only be letters or -.

What should be the appropriate validation rule to assign this field or would I have to work outside the validation rules to make this work.

Answer 1

A simple validation rule for full name should include only letters, space, hyphen and possibly apostrophe

This one works without apostrophe included

Not Like "*[!a-z -]*"

It validates that any characters not in that set are not allowed

A couple of great sources for validation examples:

• Allen Browne's page
• tekstenuitleg.net