|  | Checkbox Values No Longer Yes/No (Visible Text) |  | |
| | | Londa Sue |  |
| Posted: Thu Sep 25, 2008 2:43 pm Post subject: Checkbox Values No Longer Yes/No (Visible Text) |  |
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 |  |
| Posted: Thu Sep 25, 2008 2:58 pm Post subject: RE: Checkbox Values No Longer Yes/No (Visible Text) |  |
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
"Londa Sue" wrote:
| Quote: | 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, |
|
| |
|
|