Yes/No field in combo box

[keadatabase]

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.

 

[Steve Schapel]

Mkea,

In the Row Source query, put this in the 3rd column:

ReActive: IIf([Active],"Yes","No")

 

[keadatabase]

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

Mkea,

In the Row Source query, put this in the 3rd column:

ReActive: IIf([Active],"Yes","No")

--
Steve Schapel, Microsoft Access MVP

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.

 

[keadatabase]

Sorry, retract! It does work. I'm a dork. Guess that's why I need help.
Thanks, appreciate it!
--
mkea

Mkea,

In the Row Source query, put this in the 3rd column:

ReActive: IIf([Active],"Yes","No")

--
Steve Schapel, Microsoft Access MVP

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.