How set value for check box - Yes/No Fields in Microsoft Access


	Back to Yes/No Fields Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

How set value for check box

Thomas Gonder

3 years ago

This one has driven me nuts several times. I have a check box in a table, and it's what I need in for my case (like just record selection). I go to the datasheet view of the table, and I want to bulk change all the No to a Yes or viceversa. But the Replace function for a table column (for check box) grays out to Current Document, and I can't see how to do just the current field! I don't want to click on 4k+ records Access!

	Kevin Robertson @Reply 3 years ago
Update Queries

	Thomas Gonder OP @Reply 3 years ago
Yes that would work (using update query). I was looking for the way to do it directly with the table if possible.

Kevin Yip @Reply

3 years ago

There is a way to do it directly in the table.  Go to table design view, change the "Yes/No" data type to "Short text."  Then all the true and false entries will be converted to text values of "Yes" or "No".  Then you can use Find and Replace (which only works with text).  Then convert the short text field back to yes/no in table design.  You should back up your table before you do this just in case.

An update query is still the preferred method, and is the *only way* to do specifically what you mentioned: change Yes to No and No to Yes simultaneously:

    UPDATE MyTable SET Field1 = Not Field1

With "Find and Replace", you can only do one step at a time.  After you change all the No's to Yes's, ALL records in the entire table will have only Yes's, and you can't change what were previously Yes back to No!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Yes/No Fields.

Next Unseen

New Feature: Comment Live View