title: Access VBA Replace function returning values from Replace string
body: <p>I am trying to use the REPLACE function to search a string and remove a charcter. Here is the code..</p>
  
  <pre><code>SELECT Test.*, Replace([Data],ChrW(10),"",(Len([Data])-2),1) FROM Test;
  </code></pre>
  
  <p>Although this is just a select stmt, the result set returns the last three characters of data from the column [Data]. Instead of starting the search in that location.</p>
  
  <p>The UPDATE statement here, does the same...</p>
  
  <pre><code> UPDATE Test SET Test.Data = Replace([Data],ChrW(10),"",(LEN([Data])-2)) 
   WHERE (((Test.[Data]) Like ("*" &amp; ChrW(10))));
  </code></pre>
  
  <p>I would still expect the search to being at the results of LEN([Data])-2. Instead only the last characters are returned. The substitution is successful.</p>
  
  <p>Any help on my oversight here would be appreciated.</p>