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.
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.