I have a form with several check boxes, some are blank others are blue. This changes from record to record. What is happening? I checked the table and the check boxes are True/False with a default of 0.
Check boxes are showing blue.
Competent Performer
Windows 8 
Access 2010 32bit
I have a form with several check boxes, some are blank others are blue. This changes from record to record. What is happening? I checked the table and the check boxes are True/False with a default of 0.
VIP
Windows 7 32bit Access 2010 32bit
A blue checkbox on a form usually indicates a Null value. The check boxes are True/False with a default of 0 - but do they actually contain 0? When you look at the table, are any of the fields blank?
Competent Performer
Windows 8 Access 2010 32bit
I found the problem. I had records that didn't belong in that table. Deleted records, blue went away. Thanks, if you hadn't mentioned looking at the internals I might not have found the problem so soon.
Data fields not showing on report (Yes/No, combo boxes and datepickers are showing)
To check or Un-Check all Boxes in a form
Un-Check all Boxes
Posting Permissions
Reply With Quote