Conditional formatting on Yes/No fields

[DeRochier]

I have a mystery: I have a form with two sub-forms. Both sub-forms have a Yes/No field denoting whether an item has been marked as completed.

On one subform the conditional formatting works:

Field: txtToDo
Expression is [ToDoComplete]=-1 results in the conditional formatting being applied.

However on the second subform, bound to a different table, the same conditional formatting expression has no effect:

Field: txtSubTask
Expression is [SubTaskComplete]=-1 results in no conditional formatting being applied (even though it should).

Why would conditional formatting on a Yes/No field work on one sub-form and not the other?

 

[dhookom]

Do the two controls txtToDo and txtSubTask have the same standard format properties such as background etc? Are they both text boxes?

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[Axworthy]

If [SubTaskComplete] is a checkbox, you may want to change the expression to [SubTaskComplete]=True