searching for string and then highlighting matches

  • Thread starter Thread starter Julie
  • Start date Start date
J

Julie

Hi,

I have a form that contains, a text field made up of one or more "keywords",
separated by commas. The form also has 3 memo fields.

Each record displayed in this form consists of text that includes at least
one keyword match. In other words, within one or more of memo1, memo2, and
memo3 is a match to one or more of the keywords. I am trying to figure out if
there is a way to highlight each keyword match either with a different font
color or highlight or bold, basically something that will make it easy to see
all the keyword matches on a form.

If anyone has any suggestions I would very much appreciate it.

Thanks, Julie
 
Access has never provided this, because the text box in Access cannot format
part of the text differently than the rest.

That changed in Access 2007, which does support rich text within a text box,
so it is possible in the new version. Here's how:
Highlight matches - Matching characters of search results highlighted in
text box
at:
http://allenbrowne.com/AppSearchHighlight.html
There's a free sample database to download to see how it works.
 
Back
Top