Bold and/or Color text in field from Wildcard Search
Posted on 2010-03-23
I have a home grown Access 2003 app I developed for my company that stores incident reports for accidents and injuries. There are several free text fields in the report where managers enter personal accounts of the events by themselves as well as others that may have been involved. The idea of using Access was that I created many drop-down fields prompting managers for specific details about the event and stored them in a controlled way so reporting would be very easy to do -- Create me a report where I can choose "this" date range and "that" department for all accident types matching "this". So, there are not 10 different mis-spellings of a department name, or an employee name, etc.
However, now I am being asked to create a wildcard search report where a free text phrase can be entered and then searched upon for all of the free-text fields in each record. That's the easy part, and I have this already working.
What I am trying to do though is find a way, that when the report is generated, to show all the matching records and make it so the "searched upon phrase" is somehow bolded or have the text changed color so it stands out. Since there are multiple text fields being searched, I'd like to give the user that is running the report a way to more easily pick out where it is in the report the phrase shows up that he/she was searching for.
I see this type of styling done on web searches for Google and other search engines all the time, but I have no idea how to do it with Access, or if it is even possible.
Can anyone suggest any options?