Highlight Search results

[bonekrusher]

Good Day All,

I have a wild card search query (Like "*" & [Forms]![search]![Text0] & "*") that works very well. I want to be able to have the phrase that user types in highlighted when it returns the search results on a form. I found the following thread that asks the same question using Conditional formating, but the suggested answer doesn't work. Any ideas?


http://www.access-programmers.co.uk/forums/showthread.php?t=73845&highlight=highlight+search

 

[Rickster57]

Alternative

Don't know if highlighting JUST that text is possible in a text box. As an alternative what I have done in the past is that since the form results only display data "Like" your query filter Maybe you can put at the Form header an unbound text box whose Data Source is : " Results For A Search On " & Forms![mysearchform].[typedinrequest]. Put that in big bold letters, data locked, background to the color of the for, style is flat.

Sorry I can't help exactly.

 

[bonekrusher]

Thanks for the idea. I will keep search though.

 

[bonekrusher]

Anyone else have any suggestions?