clearing a column of checkboxes

K

k. Georgiadis

In an Access table, is there a quick way to clear an
entire column of Yes/No checkboxes (i.e., setting the
entire column to the "No" condition)?
 
C

Cheryl Fischer

An update query such as the following will do that:

UPDATE [MyTable] SET [MyTable].MyYesNoField = 0


hth,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create form with checkbox les that expand and collapse sections of the form? 0
Two columns followed by single page-width column on same page 0
How do I quickly create toc in 70-pg doc that was styled in Normal 3
Excel does not accept text format! 0
Remove Identical words 0
Calculate the median value before a specified list 0
Creating a checklist with predefined comments 1
Clearing Fields in a Word Form 5

Top