Checkbox Values No Longer Yes/No (Visible Text)

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

 

[Ken Sheridan]

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