Hello
I have managed to get going a simple search routine, borrowed/copied from an MS Access forum. It finds the word or text phrase I am searching for, and it then substitutes the phrase "Found it you little ripper ....." (or similar) and it is underlined, as I want. But I also want the "Found it you little ripper ....." phrase to show up in the report as red colored text. So, it works fine but I have never been able to go that extra small step ie red color text in the resulting report.
Is there something you can suggest (not actual VBA code, I wouldn't know how or where to insert it, in the VBA spot) to go in the query against a/the particular field that would make the "Found it you little ripper ..." phrase appear in red in the report? It must be extremely simple in practice. I know very little about the code etc behind Access routines but I hope that would not be applicable for my little query? I would be greatly pleased if you could give me the query expression that works!!
The expression in the query as it stands is:
Expr1: Replace([booktext2],[forms]![Formfindword]![Text0],"<u>FOUND IT YOU LITTLE RIPPER ............</u>")
- ? I guess the extra bit (whatever it is) goes in there with this bit -- "<u>FOUND IT YOU LITTLE RIPPER ............</u>"
I'm really hoping you can help me with this ...!!! And, remember I'm an Access "dummy" so I need the actual expression, not just a vague "Oh, you just have to do [vague whatever ....] If it is html code, I'm sorry I know nothing of that either .... Sorry
Here's hoping, anyway ....
EdKerm
25th June 2019