Text only entry in a table

[Alylia]

Hi,

I need help on the design property for text only entry in a table.

Al

 

[JackP]

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")

 

[Alylia]

I want only alphabeticat characters in the field.

 

[JackP]

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.

 

[Duane Hookom]

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.

 

[John Nurick]

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.