Hi, I have a Radio button that I want to use in a Find Script but I seem to be missing a couple of things in the Parameters available: I have 2 Questions below...

1 - if I hit control F I can go to the field and click either YES or NO and then return and the search will only display the appropriate records (no problem there). How can I perform a find for all records with no value at all in this field? Is this possible at all? Or do I need to perform Omit Record and indicate both YES and NO results instead?

2 - I have tried to create a Script which does the same as above but I can't find the Script Parameter which allows me to perform a find in this way (as in a search for all YES or NO results in a Radio Button formatted field). I can't seem to find a way to tell the Find Script parameter to search for a result at all when the field is a Radio Button. Any ideas?

Much appreciated.

My first question would be, why do you have records with no value? Second thought I had was that I don't use a Radio Yes No unless I really need that "No". If not, I just use a flag_Yes field that has a value list of 1 and is formatted as a checkbox.

But, to answer your question. If you format the field to be an Edit box, rather than or as a second instance of the field on the Find layout, and enter "=" (no quotes), it'll find records with no value in the field.

To script it:

Enter Find Mode

Set Field (radio, "=")

Perform Find