Editing Yes/No column

[Dorian]

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.

 

[Rick Brandt]

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.

 

[Ken Sheridan]

You don't actually need a hidden bound column for a combo box. Access
recognizes Yes and No as Boolean constants so a value list of Yes;No as the
RowSource and a format property of Yes/No for the control will suffice.

Ken Sheridan
Stafford, England