validation rule

H

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

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
'====================================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation Rule for an * 3
Validation Rules for a Control on a Form (?) 4
Text function names ending in "$" 2
Setting a default zoom in Infopath 0
validation rule (for a record in a table) with dlookup 7
Validation Rule 1
email validation 6
How to specify a validation rule with multiple criteria 3

Top