Hello,
I am trying Replace Double Quote in code ( ") with wild card . It throws Runtime error '3075' -- Missing operator in query expression.
Dim strComment As String
Dim stra As String
Dim strb As String
Dim strAE As String
Dim strBE As String
stra = "'"
strb = """"
str1AE = "`"
str2BE = "`"
strComment = [Forms]![Test Form1A]![Comment] & ""
strComment = Replace(strComment, a, strAE)
strComment = Replace(strComment, strb, strBE)
Plz advise.
Thanks