1 to 6 Letters

[Joe Frank]

How can I check that at least 1letter and no more than 6 letters have been
entered in a textbox?

 

[fredg]

How can I check that at least 1letter and no more than 6 letters have been
entered in a textbox?

Set the Validation property to:
Len([ControlName]) Between 1 And 6
Set the validation Rule to:
Must enter 1 to 6 letters.

 

[Wayne Morgan]

If you set the Input Mask to

L?????

The first character will be required, the others are optional. This mask
will limit the input to alpha characters only.

--
Wayne Morgan
MS Access MVP

How can I check that at least 1letter and no more than 6 letters have
been
entered in a textbox?

Set the Validation property to:
Len([ControlName]) Between 1 And 6
Set the validation Rule to:
Must enter 1 to 6 letters.

 

[Van T. Dinh]

You keep asking the same question in different newsgroups with slightly
different variations and you going to get different answers that can only
confuse you.

It is much better to word your question for precisely what you need in ONE
newsgroup and you get more applicable answers ...

Please see http://www.mvps.org/access/netiquette.htm