Validation rule for entering "A" or "B" or "C" in Access 2002

  • Thread starter Thread starter Joanne
  • Start date Start date
J

Joanne

After working too many hours, I am sure I am just brain dead.

Can someone help me with the following:

I have a form that asks questions. Most questions are Y/N answers and not a
problem. Some, however, can be answered Y or N or X - where the X is for
not applicable. I cannot get this to work in either validation rules or
modules.

Should be simple. Do not want to use lookups.

Thanks,
Joanne

(e-mail address removed)

take out removethis to answer by email
 
Joanne said:
After working too many hours, I am sure I am just brain dead.

Can someone help me with the following:

I have a form that asks questions. Most questions are Y/N answers
and not a problem. Some, however, can be answered Y or N or X -
where the X is for not applicable. I cannot get this to work in
either validation rules or modules.

Should be simple. Do not want to use lookups.

Thanks,
Joanne

(e-mail address removed)

take out removethis to answer by email
Click to expand...

I assume this is a text field, so it can receive such values? You can
use this for a validation rule on the field:

In ('Y','N','X')
 
Yes, I tried it. That is how I have the Y/N.

In ('Y','N','X') that Dirk Goldgar gave me worked fine.

Thank you.

-Joanne
 
Back
Top