Displaying Yes/No as Yes or No instead of -1 and 0

  • Thread starter Thread starter laeldo
  • Start date Start date
L

laeldo

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!
 
Are you saying you have a two-record table as the Row Source of the combobox?
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?
Click to expand...

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!!
 
Back
Top