Yes/No field in combo box
Thanks. I tried using an Iff statement as an expression for the third field,
which didn't work. Then I tried using it as a criteria for the third field,
which also didn't work. I can get the query to show the right thing, but
regardless of what happens when I click ! to run the query, the combo box
still shows numbers. It's very aggravating!
--
mkea
"Steve Schapel" wrote:
Mkea,
In the Row Source query, put this in the 3rd column:
ReActive: IIf([Active],"Yes","No")
--
Steve Schapel, Microsoft Access MVP
keadatabase wrote:
I have a combo box with these three fields: AttorneyID (autonumber and bound
field), Attorney (text), and Active (Yes/No). How do I get the third field
to show up as Yes or No instead of -1 or 0? The field in the table is type
Yes/No, and is formatted for Yes/No. The query that is the row source for
the box displays the words when run, but when I click on the combo box, all I
get is numbers. I haven't done Access work in several years, but I have an
old program in 2000 (I'm using 2003 now) that had several boxes like this,
which all worked fine. When I open it up in 2003, I get the numbers. I can
work around this if I have to, but it is really driving me nuts. Thanks.
|