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

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

BruceM via AccessMonster.com

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

laeldo

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?

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top