Change Text Box to Check Box

[Igor]

Hello, everyone,

I have yet another dumb question:

I'm trying to change a Text Box into a Check Box but the option check box is
grayed out.

What can I do?

Thank you for your help!

 

[fredg]

Hello, everyone,

I have yet another dumb question:

I'm trying to change a Text Box into a Check Box but the option check box is
grayed out.

What can I do?

Thank you for your help!

Why not just delete the text box and add a check box?

 

[Igor]

Easy enough! Thanks, I hadn't thought of that.

 

[oldblindpew]

Fred wrote "why not just delete the text box and add a check box?"

This is true, but it misses the point. Access seems to offer a capability
for changing controls from one type to another, but it doesn't work in this
case. You can go back to your table and make sure your field is a Y/N type
but it won't matter. You can make the textbox unbound by deleting the
reference to the source field, then try converting the unbound text box into
a check box, but it won't work. You can try changing the text box into some
other type, and then try changing from that into a check box, to no avail.
There is no obvious reason why this conversion could not be done, but for
some reason (presumably a good one), Access will not do it.