validation rule

[Haff]

I'm using ACCESS 2003 and need to design a validation rule for a text field
in my dB. I want to restrict the user from entering an * in the field. This
is not meant to be a wildcard, but rather a character.
In the FORM, DESIGN VIEW, PROPERTIES, VALIDATION RULE, I'm using the
following (among many different permutations), which don't work:

= [CASE NAME] NOT LIKE "*"

Can someone help? Thx.

 

[John Spencer]

Try entering the following

Validation Rule: Not Like "*[*]*"

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================