Check Box Field

[DBFIN]

Is it possible to create a field in a table that stores only two possible data choices: a check or null value ?

 

[csh2013]

By their nature, checkboxes store values of 1 for checked and 0 for unchecked. Why would you need to store a null value?

 

[DBFIN]

I don't need to store null. I created field 1 in the table with a data type of yes no. The form check box has data source field 1 and stores values of true or false in field 1. This was the only way I know. I didn't see a data type of check box when choosing the data type for field 1.

 

[csh2013]

If I understand correctly, your table is working correctly by storing a checkbox value of checked vs. unchecked, but your form doesn't have the checkbox, but rather a text box showing True/False values. Is that an accurate statement?


If so, you have the wrong control type. In the design view of your form, you'll have to use the design tab and select the checkbox control from the controls menu on the ribbon. Insert the checkbox on your form and then use the Properties menu to link it to your Field 1 on your table. This shows the results in a checkbox format rather than a True/False text box.

 

[DBFIN]

I think we are saying the same thing. My form already has a checkbox linked to Field 1, but field 1 has true/false property. So when I select a check in the form checkbox, it stores True in Field 1. I was expecting to see a check in field 1.

 

[csh2013]

Nope. I was backwards. Your form is the one that has the checkbox. In the design view of your table, go to the lookup tab at the bottom and change the display control from Text Box to Check Box.

 

[DBFIN]

That's exactly what I needed. Thank you so much. Your help is greatly appreciated !!!