Field Data help

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

 

[Clifford Bass]

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

 

[Swordfish]

Thanks Mr Bass,

It works great!

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

 

[Clifford Bass]

Hi,

Good to hear. You are welcome!

Clifford Bass