Can you post an example?
I can imagine several possible explanations but would prefer not to guess.
I've had this happen. What kind of selection tool are you using on the value list? Usually it means that there is more than one value in the field. The one with the value you didn't want, can you expand the field (without the selection tool attached) and see if your searched for value is on the second line? :smileyhappy:
For example: I have a value list with check boxes including:
and when I use the View->Find View function I click on "Local Press" and my result turns up "Local press" listings and "national press" listings as well.
I tried to constrain the list by finding again on "Local press" "constrain" but I still get "National Press" along with "Local."
I do Find View for "Newsletters" and get only "Newsletters" as I would expect. Same with "Quarterly Publications."
I suspect there may be text in your field that is hidden by the check box format that is resulting in issues when you perform a find.
Just to be sure, I tested a demo file with a check box with National Press and Local Press as the two values and confirmed that selecting National Press in find mode does not find entries only marked with Local Press and vice versa.
Place a copy of your field next to the check boxes, but use Field/control | Setup to format it as an Edit box instead of check boxes. Resize the field to be several lines of text tall.
Now perform your find and examine the edit box formatted field to see if there is any hidden text in your field that's causing the problem.
Thanks. Will give that a try when I get to work tomorrow.
Hey Phil, I am having the same trouble. I have a field labeled "status" that is based on a value list that contains..
Non Active Client
Any search for Active Client results in showing both Active Client and Non Active Client and visa versa. Any search for Non Client results in showing Non Active Client and visa versa.
What gives? And more importantly how do I stop this. I have tested this with a demo file to ensure there is not some unwanted data stashed in the field.
When you search, each word is searched individually. So if you type Active Client, it will find any record with Active Client or Client Active or Non Active Client. If you type several words within a single field, FM will find them all regardless of where they land in the field - they are treated like an AND find request. See FM Help "Finding text and characters" for several examples. It seems strange but that's the way it works. To find exact start with two equal signs. :smileyhappy:
By the way, if you want to script this exact type of find, it could be:
Enter Find Mode [ Pause ]
Modify Last Find
Set Field [ your field ; "==" & your field ]
Perform Find [ ]
if the person types active client then it will not find non active client this way.
Thank you Luna, that worked.