Highlight Text in Field After Filter

[NadiaVKhan]

Hello.

I have a search form that runs a filter based on a query. When I type a word to search and click a command button to run a requery, how do I get the the words that I searched to be highlighted in the fields below?

I found this website: http://allenbrowne.com/AppSearchHighlight.html

However, I am not able to change my fields into Rich Text in the form as I recieve the error: "The setting you entered isnt valid for this property"

 

[jdraw]

See if this info on conditional formatting gives some insight/options

 

[NadiaVKhan]

Thank you!. Its almost perfect.

However, I am having some difficulty in the EditFormattingRule popup.

You see, I want to format cells whereever the FieldValue is LIKE the SearchFieldValue on the same form.

For example, my txtSearchName has a value of Brian. The txtNameFields have values of "Brian Smith" , "Brian Night", "Brian Anderson". Unfortunately, I can only "Format only cells were the field value is BETWEEN/NOT BETWEEN/EQUAL TO/ NOT EQUAL TO/ > / < / txtSearchName.

 

[NadiaVKhan]

In other words, its as though the condittional formating is expecting a NUMBER as opposed to words