Text only entry in a table

  • Thread starter Thread starter Guest
  • Start date Start date
Can you be more specific?

Are you trying to format a text field?
Do you wish a text field to only take alphabetic characters ? (in which case
look up "input masks")
 
Use the InputMask property on the form.
Set as one of the following -- all of my examples are 6 characters long.
Expand to suit.


LLLLLL - A to Z allowed; all 6 characters must be entered
?????? - A to Z allowed; entry can be less than 6 chars

similarly, if you look up "input mask property" in microsoft access help it
will tell you the other possibilities.
 
You might want to set the Validation Rule property to
Like "*[a-zA-Z]" And Not Like "* *"
This will allow any number of characters to be entered and won't accept
numbers or spaces.

Someone more familiar with Regular Expressions might have a better solution.
 
Hi Duane,

I think this

Not Like "*[!A-Za-z]*"

is neater, but like your expression it may not be satisfactory
satisfactory because it excludes accented characters and characters that
are alphabetical in some languages (such as å ä ö in Swedish). I think
the best that can be done with a validation rule is something like this
but with a longer list of letters:

Not Like "*[!A-Za-zÁÅÄÉáéåäÖö]*"






You might want to set the Validation Rule property to
Like "*[a-zA-Z]" And Not Like "* *"
This will allow any number of characters to be entered and won't accept
numbers or spaces.

Someone more familiar with Regular Expressions might have a better solution.
Click to expand...
 
Back
Top