Checkboxes on Reports - Help with Expression Builder

[adamdunko]

I am building 2 reports that will have checkboxes on them. On the first one, there is only one field to consider (a date field) so I just used that field name as the control source for the checkbox on the report-- the result being that if there is any value at all, the box will be check on the report, and if it is null the box will be unchecked. This happens automatically, regardless of the data type of the control source.

Now on the second report is where I have my problem. On this report, I need to use expression builder to look at 2 different fields from the associated query to determine whether to check the checkbox on the report. One field is a date field and one is a checkbox. For example:

The checkbox field needs to be UNCHECKED and the date field needs to have ANYTHING in it. If these conditions are met, I want the checkbox on the report to be checked, if not, unchecked.

So this is what I tried (using Expression Builder) as the control source for the report's checkbox:

=IIf([Complete Monograph List]![GRANULATION REVISION -001] Is Not Null And [Complete Monograph List]![GRANULATION RETIRED] Is Null,Yes,No)

thinking that if the condition is met (TruePart) it will return a Yes to the checkbox, and if not (FalsePart) it will return a No....

The result is that no record on the report is checked at all. Can anyone offer any advice on what else to try or what may be wrong with this expression!?

 

[adamdunko]

Okay I figured out what my problem was....
The Checkbox field in the Query cannot be said to be null... it has to be referred to as False.

 

[Quintios]

Thanks for posting the solution! Star for you!

thx!

Q-