How do I restrict values to specific characters?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to restrict field entry on a telephone field to numeric
characters, spaces, hyphens, brackets and fwd slashes.
 
You can do this using the format facility in the database design table or
the control properties if it is in a form
Tony
 
In addition to any other suggestions, the following entry in the
ValidationRule property of the relevant field in the relevant *table*,
would stop the user entering any characters *other than* space, 0-9, (,
), /, or - in that field:

Not Like "*[! 0-9()/-]*"

You'd also wan to put a suitable error message in the ValidationText
property.

HTH,
TC (MVP Access)
http://tc2.atspace.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

preventing unwanted characters 5
Validation Rule - Access 97 VS 2002 6
Special characters 3
Restricting character range 1
dash/hyphen issue 4
Delete Specific Characters From Text 1
Remove non numeric characters from field 4
Data validation, mandatory and restricted field length for excel vbs 10

Back
Top