Yes/No data field help

[Christy]

Hello-

I have several fields in Access that are Yes/No data types but I want them
to be 0,1 in the TABLE and have a check box in the Form. How do I do this?

When I choose the Yes/No Data Type in the table it defaults to the checkbox
but I am guessing I can change this to text I still get yes and no when I do
Combo box I can change the choices to 0,1 but I am unsure then how to change
the combo box to a checkbox in the form.

Thanks!

 

[boblarson]

If the datatype is YES/NO then you can just delete the combo box and then
drag and drop a checkbox on to your form. Then, in the checkbox's
recordsource select your yes/no field from the list.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.