Is there a way to search an Access (2010) rich text memo Form field with VBA code to find if the HTML tag for the red color, or any other color for that matter, is being applied somewhere in that rich text memo Form field and if it is not, then perform some VBA code? I want to use that code in a Before Update Event for another field (checkbox) on the Form to determine if red formatting was used somewhere in the Memo field and if it wasn't not update the checkbox to true and then inform the user with a MsgBox that there was no red formatting in the Rich Text Memo Form field. Thanks.