Yes/No field check box

[Guest]

I have a yes/no field in my table. I have created a form for this table, but
the control for this field shows up as a text box. How can I change this to
be a check box, so that when the user checks the box the field in the tabls
shows as "yes" or "true"?

 

[Guest]

How did you generate the check box on your form? Did you view the field list
and drag the check box control to your form? If not, have you changed
anything on the table on the lookup tab? did you select text box there? it
should be check box.

 

[Graham R Seach]

Just add a CheckBox to the form, then just set its ControlSource property to
be the field you want to bind it to. Also set its DefaultValue property to
True (yes) or False (no), as appropriate.

Regards,
Graham R Seach
Microsoft Access MVP
Canberra, Australia

 

[Guest]

Thanks so much for this response - I went back and checked how my field was
set up and realized I had set it up as a text box, so I changed it to
checkbox. That allows me to add the check box control to my form, but now I
have a new problem - when I try to use the form, I cannot check or uncheck
the box. I do not even get an error message, so I'm not really sure wha the
problem is. Any ideas?

 

[Guest]

Sorry, I didn't notice you had re-posted, have you still got problems but
guess you must have sorted them by now?????