Highlight text in memo field

[silverspr]

I have a report with a memo field called "TestG" set to rich text containing several items separated by a comma: "calcium, phos, cbc, swab, ethanol". I want to be able to highlight or change the font color of the instance of ethanol and cbc only, not the entire row. Does anyone have a macro which can be run from a report on format event to achieve this...



thanks in advance for your help

[ajetrumpet]

try: http://www.google.com/#sclient=psy&h...50e40e87b009cf

[silverspr]

I should have mentioned the several items separated by a comma: "calcium, phos, cbc, swab, ethanol". are sorted alphabetically...it seems inserting the html tags causes the sort to go out of sorts...sigh