CheckBox Question

[depawl]

OK, I have a rather large excel spreadsheet that I need to import into Access (2007). The spreadsheet has numerous “Yes/No” fields (users enter a “1” for Yes, and leave it blank for No). The majority of the fields (several hundred) are left blank (indicating No). The Yes/No fields will appear as checkboxes on an Access report. After importing the spreadsheet to an Access table, then creating a report from the table, all of the checkboxes for the “No” fields show up shaded. I would prefer to have them open as unchecked. I have set the Triple State property for the check box control to “no” but it seems to have no effect.
Thanks.

 

[JHB]

Run an update query after import, set the null value to 0

 

[depawl]

Is there a way to do this across the whole table or does it have to be done one field at a time?
In other words:
UPDATE [Table 1] SET [Table 1].[1st Field] = 0
WHERE ((([Table 1].[1st Field]) Is Null));

This table has dozens of fields.
Thanks.