title: Access VBA | How to replace parts of a string with another string
body: <p>I am trying to create a piece of code that replaces one word with another.
  Example: Replace Avenue with Ave and North with N.
  I am using MS Access, I could use SQL REPLACE Function but I want to do this in VBA using Access module so that I can attached the function to other column.</p>
  
  <p>I am not sure where to start with this, so any input will be greatly appreciated.</p>
  
  <p>Guy</p>