Yes/No Field

[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?

 

[J_Goddard via AccessMonster.com]

HI -

Did you consider using checkboxes for these fields instead of textboxes? It
doesn't change how the data is stored in the tables. A Yes/No is stored as 0
or -1 = "Yes" or "No" is just a display format. If your users don't like
having to use the mouse, a checkbox can be toggled with the spacebar.

John

 

[John W. Vinson]

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?

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.

 

[Mike Painter]

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?

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.