Check Box Error on Report

[velcrowe]

I have a report with an if then statement for a checkbox.

If checkbox is true...etc versus if checkbox is false...etc

When there isn't a record that has this checkbox checked, I get the error

"You entered an expression that has no value." (Runtime error 2427) How can I ignore this error

when the record doesn't apply to the criteria?

 

[GohDiamond]

Checkbox values are "-1" for True and "0" for false try this:
if mycheckbox = -1 then ......
'action to take when true or checked inserted here
Else
'action to take when false or unchecked inserted here

if the error persists use Nz([mycheckbox],0)
this will make all null checkboxes equal to 0

Let us know if that helps

Cheers,
Goh