Filter Setting Problems

[Guest_imported]

if there's a check box that will only allow a user to tick. that's a YES/NO check box. in the filter i want to display those check box haven't &quot;tick&quot; or &quot;NO&quot; ..... i use &quot;Condition<>YES&quot; in the filter property , <condition> is a Name of the check box, wrong?

 

[JerryDennison]

A checkbox can be one of three values, True(any integer other than zero), False(0), or null(no value at all). When testing you should always use either True or False rather than &quot;Yes&quot; or &quot;No&quot;. Yes/No are formatting options more than they are test options. So, if you want to return ONLY &quot;No&quot; values you should test for False values, otherwise you'll return values that are not True (i.e. either False or Null).

&quot;[YesNoFieldName] = False&quot;