I've added a Yes/No field to a form. I'm trying to update existing records with the default value (No). I set up an update query that replaces a null (Is Null in query) value with 0 (No).
When I look at the data sheet, the new field shows an empty check box instead of a 0. I've compared the form field properties and the table properties but I can't see what's wrong. The only disrepancy was in the table design. For this new field, both the data type and the format show Yes/No. For existing Yes/No fields, only the data type shows Yes/No; the format shows nothing. I tried deleting the Yes/No value from the format of the new field, but the change wouldn't stick.
As far as the data and the end user, this might not even be a problem. I'm just concerned when I see an inconsistency like this.