Field Data help

  • Thread starter Thread starter Swordfish
  • Start date Start date
S

Swordfish

I have a field in a form which has a control source, that I would like to
have open for alpha-numeric input but not less than 4(either alpha-numeric)
characters, not more than 11 characters and no spaces between characters. I
have tryed the "Like" command in the validation rule in the table design of
the field with variest arguments, but this does not seem to be work. Any
ideas?

Thanks for the help.
 
Hi,

In your table define the column as being 11 characters in length; that
will take care of the maximum number. In the column's Validation Rule
property place this:

Like "????*" And Not Like "* *"

Since the default error will look cryptic to the user, use the
Validation Text property to provide a more user-friendly message.

Clifford Bass
 
Thanks Mr Bass,

It works great!

Clifford Bass said:
Hi,

In your table define the column as being 11 characters in length; that
will take care of the maximum number. In the column's Validation Rule
property place this:

Like "????*" And Not Like "* *"

Since the default error will look cryptic to the user, use the
Validation Text property to provide a more user-friendly message.

Clifford Bass
Click to expand...
 
Back
Top