FileMaker would store text in numeric fields, but you can not search on it. Why would you put text data into a numeric field?
if you need text and numbers use text data type.
i almost invariably set strict datatype validation on numerics to prevent text entry
when I started diving into this, I think the real difficulty is searching for/querying an "interpretation" of null.
I think that if you want to stick to 0/1/null, you need to script the find process. Otherwise, you might consider a text field with a 3-value list. That's all.
Do you want "boolean" formatting on number field, but finding with text?
Maybe I wasn't that clear. The field is numeric, I have a text that displays (an object, not data)
So if the field has a "1" "Yes" might display, if it is null or "0" a "No" would display (or other words than Yes/No)
When the user wants to search for "No" they cant.
As suggested earlier, a scripted Find would help but otherwise you'd be best off creating a calculated text field such as:
SearchField = Choose ( dataField + 0 ; "No" ; "Yes" )
and then perform your find based on searchField.
to add to my previous response, you can search for the words associated with one or zero, you just can't search for the thing that represents null.
- Create a table with two records and two fields: Value (number) and Definition (text).
- Populate the records with 0/1 and False/True, etc.
- Create a value list based on the values in this table: field one - Value, field two - Definition; and check "show values only from second field"
- Base your pop-up on this value list and now you can find "zero" or "one" or whatever.