Limiting character type

[H. Martins]

How do I limit the character types entered in a textbox?

Say, I want to accept as valid characters numbers, letters and '-'
only.

Could that be limited in the table itself?

Thanks
Henry

 

[Allen Browne]

Could I talk you out of allowing the dash in this field?
Access behaves inconsistently with that character:
http://support.microsoft.com/kb/271661/en-us

To limit the field to digits and letters only, open the table in design view
and place this validation rule on the field:
Is Null OR Not Like "*[!((a-z) or (0-9))]*"

For an explanation, see:
http://allenbrowne.com/ValidationRule.html

 

[Marshall Barton]

How do I limit the character types entered in a textbox?

Say, I want to accept as valid characters numbers, letters and '-'
only.

Could that be limited in the table itself?

Yes. Set the field's Validation Rule to:

Is Null Or Not Like "*[!-0-9a-z]*"