Prev: How to add record in Subform which is in another Subform
Next: Clearing a field
From: laeldo on 25 May 2010 11:18
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!
From: BruceM via AccessMonster.com on 25 May 2010 12:51
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

From: laeldo on 25 May 2010 13:09
On May 25, 12:51 pm, "BruceM via AccessMonster.com" <u54429(a)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!!
 | 
Pages: 1
Prev: How to add record in Subform which is in another Subform
Next: Clearing a field