Search Replace on a Yes/No Field

[Robert Willis]

I have two Yes/No fields in my Microsoft Access 2003 SP3 database that I
would like to reset to No. I cannot get the Replace Function to work from
the toolbar on these two fields. When I select the column the Replace box
only list the table name instead of the field name. What am I doing wrong?

 

[Allen Browne]

Do this in a query.

In query design view, choose Update from the Query menu.
Access changes it into an Update query (adds Update row.)

In the Update row under your Yes/No field, enter:
False

Run the query, and all records in the table will have No in this field.