Small issue after upgrading from 2000 to 2002

  • Thread starter Thread starter Jose Olivas
  • Start date Start date
J

Jose Olivas

I have a database which I have had since Access 97, I just upgraded 2000 to
2002. The database has a data entry form that has 15 check boxes. These
check boxes use to put a "yes" value if check and a "no" value if unchecked
into the data table cells. Now if checked it puts in a -1 and leaves every
unchecked cell blank. How do I resolve this? My queries are not pulling up
the -1 value.

Thanks for the time in advance.
 
I have a database which I have had since Access 97, I just upgraded 2000 to
2002. The database has a data entry form that has 15 check boxes. These
check boxes use to put a "yes" value if check and a "no" value if unchecked
into the data table cells. Now if checked it puts in a -1 and leaves every
unchecked cell blank. How do I resolve this? My queries are not pulling up
the -1 value.
Click to expand...

The stored value for True is (and always has been) -1, 0 is False. You
may need to set the Default property of these checkboxes to False.
 
Back
Top