View Single Post
  #2  
Old May 25th, 2010, 05:51 PM posted to microsoft.public.access.forms
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default Displaying Yes/No as Yes or No instead of -1 and 0

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