Checkbox Values No Longer Yes/No (Visible Text)

  • Thread starter Thread starter Londa Sue
  • Start date Start date
L

Londa Sue

The database has a checkbox for determining whether an asset is valid or not.
Users check "yes" if it is; "no", if not. A couple of days ago, I noticed
that the Yes/No text that normally appears in the list box is now -1/0. I
checked the tables and queries; however, I cannot determine what happened or
how to have the text values reappear.

Thanks for your help,
 
Boolean (Yes/No) values in Access are implemented as -1 for True and 0 for
False. 'Yes' or 'No' is a formatting of those values, so to show them as
such in a list box its RowSource would need to format the column, e.g.

SELECT Asset, Format(IsValid,"Yes/No") FROM Assets ORDER BY Asset;

where Asset and IsValid are columns in a table Assets. A column can also be
formatted by means of the Format property of a query used as the RowSource.

Ken Sheridan
Stafford, England
 
Back
Top