Computer Learning Zone
Highlight Search Matches Inside Microsoft Access Text Boxes
16:58
Conditional formatting can flag an entire field, but that is not much help when a long notes box contains several paragraphs. In this episode, Richard Rost shows how to highlight every occurrence of a search word or phrase inside a Microsoft Access text box without changing the original table data.
The discussion uses VBA, rich text controls, HTML-style formatting tags, and the Replace function…