How to Filter, and highlight matches in a search

[Terry Stevens]

I search with code like this:
' Search Title and Description
strWhere = strWhere & "([Title] Like ""*" & Me.Text188 & "*"") OR "
strWhere = strWhere & "([Description] Like ""*" & Me.Text188 & "*"") AND "
'Finally, apply the string as the form's Filter.
Me.Filter = strWhere
Me.FilterOn = True

Q. Description is a MEMO field
Q. If for example: Me.Text188 is 'Stevens Home'
How can I get the resulting found strings to be highlighted in a different
colour?

 

[Allen Browne]

You can do this in Access 2007 only, since the text box in previous versions
did not support rich text.

Details and example in:
Highlight matches
at:
http://allenbrowne.com/AppSearchHighlight.html