Search/Replace Checkbox

[bhammer]

When I Ctrl+F for -1 in my table with a yes/no field the search says no
records. In my form using a checkbox bound to that field, the search also
says no records. It also cannot find records with Null, 0, True, False, Yes
or No by using the Search/Replace dialog. Why not? How can I do this? (I am
able to Filter for Null and -1 however.??)

 

[Allen Browne]

The Find dialog is not searching the y/n field.

When you select a text box and open the Find dialog, you can set the Look In
option to the "current field" or to the "form." When you select a check box,
"current field" is not available.

The Find dialog is of limited use. Create an interface to filter the form,
e.g.:
strWhere = "[YourYesNoFieldNameHere] = True"
Me.Filter = strWhere
Me.FilterOn = True