Validation Rule for an *

[Haff]

I'm using ACCESS 2003 and don't want the user to enter any * in the field.
(This is a character, not a wildcard.) In FORMS, DESIGN VIEW, PROPERTIES,
VALIDATION RULE, I'm entering (among several permutations):
= [Case Name] Not Like "*"

It doesn't work. Any suggestions? Thx.

 

[Dirk Goldgar]

I'm using ACCESS 2003 and don't want the user to enter any * in the field.
(This is a character, not a wildcard.) In FORMS, DESIGN VIEW, PROPERTIES,
VALIDATION RULE, I'm entering (among several permutations):
= [Case Name] Not Like "*"

It doesn't work. Any suggestions? Thx.

Try:

Not Like "*[*]*"

 

[KARL DEWEY]

Try this --
<> Chr(42)

 

[John W. Vinson]

I'm using ACCESS 2003 and don't want the user to enter any * in the field.
(This is a character, not a wildcard.) In FORMS, DESIGN VIEW, PROPERTIES,
VALIDATION RULE, I'm entering (among several permutations):
= [Case Name] Not Like "*"

It doesn't work. Any suggestions? Thx.

The LIKE operator is treating it as a wildcard. This rule will fail for a
couple of reasons! If your field only has one character and you want that
character to NOT be an asterisk use a validation rule of

<> "*"

If you want to prevent entry of an asterisk anywhere within a longer field,
you need to wrap the asterisk in square brackets so that LIKE will realize you
mean it literally:

NOT LIKE "*[*]*"

The leading and trailing asterisks mean you want to exclude a literal asterisk
anywhere within a string of other characters.