My audit trail in Access contains the line below.
It works fine until there is an single quote in the BuildStr and then it fails.
How do I amend the "BuildStr=" code below to cater for the single quote.
Syntax error (missing operator) in query expression ''** Address1 Changed From: 17 Main Street , NewYork To: 17 Main Street , NewYork O'Brien
(Note the surname O'Brien has a single quote)
BuildStr = "** " & ccont.Name & " Changed From: " & ccont.OldValue & " To: " & ccont.Value & Chr(13) & Chr(10