View Single Post
  #1  
Old May 25th, 2010, 04:18 PM posted to microsoft.public.access.forms
laeldo
external usenet poster
 
Posts: 6
Default Displaying Yes/No as Yes or No instead of -1 and 0

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!