1 to 6 Letters

J

Joe Frank

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

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.
 
W

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


fredg said:
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.
 
V

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
 
Top