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.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.