Yes/No Field

  • Thread starter Thread starter Cbeckwith
  • Start date Start date
C

Cbeckwith

I have fields in the backend table that are set for YES/NO on type. However,
my users just want to use a Y for YES or N for No, instead of having to
keystroke the entire "YES" in the field on the Frontend database. Is there an
easy way to just enter an Y or N for controls using the Yes/No field type?
 
I have fields in the backend table that are set for YES/NO on type. However,
my users just want to use a Y for YES or N for No, instead of having to
keystroke the entire "YES" in the field on the Frontend database. Is there an
easy way to just enter an Y or N for controls using the Yes/No field type?
Click to expand...

Are you having the users enter data directly into the Table? If so, *don't*.
That's not the function of tables!

Use a Form instead, bound to the table. You can use a checkbox as John Goddard
suggests, or a Combo Box with either "Yes" and "No" or "Y" and "N" displayed,
rather than a textbox.
 
Cbeckwith said:
I have fields in the backend table that are set for YES/NO on type.
However, my users just want to use a Y for YES or N for No, instead
of having to keystroke the entire "YES" in the field on the Frontend
database. Is there an easy way to just enter an Y or N for controls
using the Yes/No field type?
Click to expand...

If you need to see the "Yes" or "No"
then default to teh more common one
In the on-click event
you can set

If me.YourYesNoField = True then
me.YourYesNoField = False
else
me.YourYesNoField = True
End If

If it can be left blank then a Case statement can be used to select between
three values.

It's very fast for a two or three items but a combo is better once you get
past that value.
 
Back
Top