If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Yes/No field in combo box
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. -- mkea |
#2
|
|||
|
|||
Yes/No field in combo box
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
Yes/No field in combo box
Sorry, retract! It does work. I'm a dork. Guess that's why I need help.
Thanks, appreciate it! -- 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. |
#5
|
|||
|
|||
Yes/No field in combo box
=?Utf-8?B?a2VhZGF0YWJhc2U=?=
wrote in : Sorry, retract! It does work. I'm a dork. Guess that's why I need help. Thanks, appreciate it! Seen http://support.microsoft.com/kb/945280 for an explanation of your problem and some othercombo box problems with Office Service Pack 3 -- Bob Quintal PA is y I've altered my email address. ** Posted from http://www.teranews.com ** |
Thread Tools | |
Display Modes | |
|
|