Question How dpes one reference a checkbox status in an expression?

eepok

Noob. Well, mostly noob.
Local time
Today, 15:11
Joined
Oct 30, 2007
Messages
112
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")
 

Users who are viewing this thread

Back
Top Bottom