Simple question:

How does one reference a checkbox status in an expression?

I have a bunch of checkboxes [FC1YN] through [FC4YN] and need to know how to reference them in an if/then statement. I thought "yes" and "no" values would be appropriate being that they are "yes/no" fields, but I only got errors:

TEST: IIf([FC1YN]="yes","w0000t","FAIL")

I didn't even get "FAIL"... just error.

Try

TEST: IIf([FC1YN]=True,"w0000t","FAIL")

Try

TEST: IIf([FC1YN]=True,"w0000t","FAIL")

That's the magic! Thank ya kindly =)