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
|
|||
|
|||
Displaying Yes/No as Yes or No instead of -1 and 0
Hi, this should be simple but it's still giving me trouble. I have a
drop-down combobox that is referencing a table with two columns, like this: 0 No 1 Yes The column count is 2 and the column widths are 0";1" but the drop- down displays 0 and -1. I know that this is how Access stores yes/no, but can't I get it to store 0 and 1 instead and display the words instead of the numbers? Thanks for the help! |
#2
|
|||
|
|||
Displaying Yes/No as Yes or No instead of -1 and 0
Are you saying you have a two-record table as the Row Source of the combo box?
If so, what are the data types of the two fields? To what type of field is the combo box bound? Is there a reason you don't want to store the Boolean (Yes/No) values? laeldo wrote: Hi, this should be simple but it's still giving me trouble. I have a drop-down combobox that is referencing a table with two columns, like this: 0 No 1 Yes The column count is 2 and the column widths are 0";1" but the drop- down displays 0 and -1. I know that this is how Access stores yes/no, but can't I get it to store 0 and 1 instead and display the words instead of the numbers? Thanks for the help! -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
Displaying Yes/No as Yes or No instead of -1 and 0
On May 25, 12:51*pm, "BruceM via AccessMonster.com" u54429@uwe
wrote: Are you saying you have a two-record table as the Row Source of the combo box? If so, what are the data types of the two fields? *To what type of field is the combo box bound? Is there a reason you don't want to store the Boolean (Yes/No) values? laeldo wrote: Hi, this should be simple but it's still giving me trouble. I have a drop-down combobox that is referencing a table with two columns, like this: 0 * *No 1 * *Yes The column count is 2 and the column widths are 0";1" but the drop- down displays 0 and -1. I know that this is how Access stores yes/no, but can't I get it to store 0 and 1 instead and display the words instead of the numbers? Thanks for the help! -- Message posted viahttp://www.accessmonster.com I checked the data type of the two fields and changed them both to text and now it works! I want the words to display for the data entry people, who find the numbers confusing. I prefer to store the values as 0/1 since this is the convention that we use for everything else and will make data analysis simpler. Thanks!! |
Thread Tools | |
Display Modes | |
|
|