searching for string and then highlighting matches

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
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
Print (physical or pdf) not respecting format of source document 0
How do I set focus (and select text) on a text box on a modeless userform? 0
How do I convert shading to highlighting for specific colors 8
InputBox for a string of 2 to 3 keywords, separated with commas. 2
adding similar information 1
Query of three fields simultaneously 3
Only display fields if field matches criteria 1

Top