making me gray

[barret bonden]

Access 2002; getting "half gray" check boxes on a report. These are yes/no
check boxes and I cant see anything
different I'm doing to them - some are checked, some are blank white (and
this is fine of course), but some show and
print as gray -

 

[Allen Browne]

The 'gray' state means Null (neither true nor false.)

Examples of when a check box may be Null:
- It is unbound (Control Source is blank), and has no default value.

- It is bound to a yes/no field in a query that has an outer join.

- It is bound to an expression that calculates to Null.

 

[barret bonden]

Allen:

Many thanks for the reply. Is there a "best method" to force them off gray
without changing the query they are built on ?

 

[Allen Browne]

Unbound? Set Default Value to 0.

Bound to a field? Use Nz() to deal with the null.
Example: If field is named IsPicked, change Control Source to:
=Nz([IsPicked], False)

Remember to change the Name of the check box as well. Access gets confused
if it is the same name as a field, but bound to something else.