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