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!

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