SQL Statement to Change Background Color of Words in a String

[Egan]

Hi, in Access 2013 I use a sql statement with html to highlight words in a string stored in a recordset. I’m able to use the code below to find the words in the string and change their font color. Instead of changing font color, I would like to change the words background color, for example to yellow. Is that possible? What would be the html tags to change the background color? TIA


a = Replace(Myrec("Entry"), c, "<font color=""red""> " + c + " </font>")

[Egan]

By using the highlight menu in a rich text field I was able to find the html syntax for highlighting in yellow the background color of the word to be changed in the sql statement. The code is
a = Replace(Myrec("Entry"), c, "<font style=""BACKGROUND-COLOR:#FFFF00""> " + c + " </font>")

[pbaldy]

Thanks for posting your solution, and welcome to the site by the way!

[Egan]

Paul, thanks for the thanks