Bold and/or Color text in field from Wildcard Search

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?
jmccloskAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

peter57rCommented:
It's not possible using anything in standard Access 2003.

You would need a rich text control and then programmatically add in the rich text control strings around the matched text to highlight the occurrences.  How you would do that will depend on you finding a suitable rich text control and on it's method of operation.  There used to be a rich text control here www.lebans.com but I'm not sure if the site author is still around now.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I realize this may not be an option, but Access 2007 does provide native RichText formatting in a Textbox. You'd have to do this through code - that is, you'd have to parse the returned text and then surround that with HTML tags to bold it.

You could also use a WebBrowser control, which would allow you to do much the same as a webpage, and use the same concept - use the Replace function in your returned data to highlight the search phrases, then display them in the WebBrowser control.
0
jmccloskAuthor Commented:
Sorry guys.  I should have qualified my questions with the facts that, (1) I was trying to do this without resorting to the addition of any 3rd party software and (2) I don't have a budget to spend money on that or an upgrade to Office 2007.
Since there doesn't seem to be a resolution to my question, based on the fact that it seems the functionality is not available within Access 2003, I don't really know how to close out this question??  Do either of you feel your answers were worth the 500 pts assigned?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.