I have the below update query in vba where I'm trying to update the contents of a field with HTML text. I need help in how to get this string of HTML contents into the field.
This is the update statement:
DoCmd.RunSQL "UPDATE branch SET branch_text = " & [strHTML] & " WHERE branch_id = " & Form_frmReport.cboChooseBranch.value
<P class=MsoNormal><B style="mso-bidi-font-weight: normal"><SPAN style="COLOR: red">This is a test of the scripting system<?xml:namespace prefix = o /><o:p></o:p></SPAN></B></P>ok
I'm getting a syntax error, it looks like i may need to escape the strhtml with quotes....?