Managing Data with Microsoft® Excel

Managing Boolean Fields and Check Boxes

One annoyance involved in bringing data from a database to the worksheet is due to Boolean fields. Booleans are also termed True/False fields, and Access often refers to them as Yes/No fields.

Boolean fields take one of just two possible values: True and False. Difficulties arise when you return their values to the worksheet because databases don't necessarily store them as TRUE or FALSE, the values you normally see on an Excel worksheet. You need to account for this, either in the database or in Excel. And check boxes, which usually result in either a True value (checked) or a False value (unchecked) can have a third value, Null (shaded).

Returning Boolean Values to the Worksheet

Suppose that your database ...