yes/no checkboxes disappeared and replaced with zeros?

[Guest]

Hi there

I am setting up a new database with several columns that require yes/no
answers. This morning, when i opened up the databse, i noticed that all the
yes/no checkboxes had been repalced with zeros and I can't get the checkboxes
back even after confirming the data type in desgin view. I even deleted the
column and created a new one, but the zeros are still there?

 

[Guest]

Access uses a 0 for false (no) and -1 for true (yes). From the sound of what
you are describing you are looking at the table. Create a form based on this
table and you can use check boxes. You should always use forms to edit and
add data.

 

[Guest]

Thanks for the quick reply. But out of curiosity, before today, the
checkboxes appeared on the table form and were functioning normally. Any
idea how to get it back to that state?

 

[Guest]

Thanks for the quick reply. But out of curiosity, before today, the
checkboxes appeared on the table form and were functioning normally. Any
idea how to get it back to that state?

 

[Guest]

Open table in design view, click on the field you want to change, at the
botom click on the lookup tab, change the display control to check box.