In query, yes/no box is checkmarked, blank, or shaded (why shaded?)

**mkfloque** · 07-01-2013, 11:29 AM

Hello All,

I have a query where I include yes/no fields from 2 different tables. When i run the query, some boxes are "shaded". In the tables, boxes aren't checkmarked. Why are these shaded? Thanks!

**RuralGuy** · 07-01-2013, 11:38 AM

The "shaded" boxes have no value yet. They are not True *or* False yet. They are Null.

In query, yes/no box is checkmarked, blank, or shaded (why shaded?)

Thread Tools

In query, yes/no box is checkmarked, blank, or shaded (why shaded?)

Similar Threads

Getting rid of a blank row when exporting query to .txt?

Multiple Query Criterea and text boxes- If one is blank, no query result

Adding Count Query to Select Query Causes Blank Screen In Subsequent Form

searching for blank fields with a query

If the query returns a "blank" how can I change the blank to..

Posting Permissions