Validation Rule and Validation Text

  • Thread starter Thread starter Cathy
  • Start date Start date
C

Cathy

I have set up a table with a field named "Participation"
and I have that field's Validation Rule property set up
as "Yes" or "No", thereby limiting the value(s) that can
be entered into the field. Users are allowed access only
to the form for this particular table. Is there a way to
limit the values for the "Participation" field in the
form? Thanks.
 
Cathy said:
I have set up a table with a field named "Participation"
and I have that field's Validation Rule property set up
as "Yes" or "No", thereby limiting the value(s) that can
be entered into the field. Users are allowed access only
to the form for this particular table. Is there a way to
limit the values for the "Participation" field in the
form? Thanks.
Click to expand...

The form should pick up the validation rule that you defined in the table.
That's pretty much the whole point of putting the rule in the table, so you
don't have to define it over and over if you use multiple forms.
 
The easiest way would be to change that textbox to a checkbox or an option
button (so long as there are no other option buttons on the form)

HTH
 
Thanks, Larry, for your input - but the validation rule
was working correctly, after all, both in the table and
the form. I will, however, keep your suggestion in mind
for a future time.
 
Cathy,

Using one of the methods I suggested you'd end up with a field limited to
one of two values.

HTH
 
Back
Top