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