When I tried it, your example produced Expression is not valid.
So, similar to my earlier example using the =IsTrue() function:
=IsTrue( Exists(%...%) or Exists(%...%) or Exists(%...%) )
You need to use:
=IsTrue( ContainsText(...) or ContainsText(...) or ContainsText(...) )
When I have a moment I will update the Flags & Icons Worked Examples with examples involving =ContainsText() and =IsTrue().
Jane and others do run FH courses from time to time, but they usually cover a wider set of features than just Expressions, Data References, and Functions.
In the meantime, have a look at Understanding Data References and Understanding Functions.
* Individual Records Window
Individual Records Window
Mike
Thank you very much. I hadn't actually loaded my version and was awaiting your comments as to whether it was correct or not.
I have now downloaded your version and confirm that all seems to be working perfevtly.
Once again my gratitude for your assistance.
I will also look Data References and Functions.
Robert
Thank you very much. I hadn't actually loaded my version and was awaiting your comments as to whether it was correct or not.
I have now downloaded your version and confirm that all seems to be working perfevtly.
Once again my gratitude for your assistance.
I will also look Data References and Functions.
Robert