title: insert unicode character into a VBA string
body: <p>Using MS Access 2003 on Windows 7, I found that the following function strips all accents from ANSI strings, changing (for example) señor to senor:</p>
  
  <pre><code>Public Function RemoveAccents(ByVal inputString As String) As String
  Const accentString As String = "ÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÏÑÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðñòóóôõöùúûüýÿ"
  Const nonAccentStr As String = "AAAAAACEEEEIIIIINOOOOOUUUUYaaaaaaceeeeiiiionoooooouuuuyy"
  Dim i As Integer
  
  For i = 1 To Len(accentString)
  inputString = Replace(inputString, Mid(accentString, i, 1), Mid(nonAccentStr, i, 1), , , vbBinaryCompare)
  Next i
  RemoveAccents = inputString
  End Function
  </code></pre>
  
  <p>But when I tried to add Latin small letter C with Caron (U-010D)(&#269;)(HTML &amp;#269;) to the function Const accentString, like this,</p>
  
  <pre><code>Const accentString As String = "ÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÏÑÒÓÔÕÖÙÚÛÜÝàáâãäåç" &amp; ChrW$(&amp;H10D) &amp; "èéêëìíîïðñòóóôõöùúûüýÿ"
  Const nonAccentStr As String = "AAAAAACEEEEIIIIINOOOOOUUUUYaaaaaacceeeeiiiionoooooouuuuyy"
  </code></pre>
  
  <p>I was unable to run the function. Is there a syntax which will allow me to adapt this function to strip the diacriticals from strings containing characters not in the ANSI character set? </p>