Editing Yes/No column

I have a Yes/No column which can be edited in continuous form view. The
values display as Yes or No. However, as soon as I click in the column Yes
changes to -1 and No changes to 0. This is VERY confusing to my users; is
there any way to prevent this and get a selection list of 'Yes' and 'No' to
change the setting rather than have to type in 0 or -1 ??? Thanks.
--
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

On Wed, 31 Dec 2008 07:13:01 -0800, Dorian wrote:

> I have a Yes/No column which can be edited in continuous form view. The
> values display as Yes or No. However, as soon as I click in the column
> Yes changes to -1 and No changes to 0. This is VERY confusing to my
> users; is there any way to prevent this and get a selection list of
> 'Yes' and 'No' to change the setting rather than have to type in 0 or -1
> ??? Thanks.

You need to use a different control (not a TextBox). Either...

ComboBox or ListBox with a RowSource showing "Yes" and "No" as choices in
a visible column but which has a hidden bound column with -1 and 0 values.

OptionGroup using RadioButtons or ToggleButtons labeled "Yes" and "No"
but with values corresponding to -1 and 0.

CheckBox. This is the most obvious and easiest to set up. Change from a
TextBox to a CheckBox and your done.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com