Replace string replacing on itself
Posted on 2011-09-04
I have a text field on a form... if a user enters Poly or Polycarb anywhere in the field I would like to replace it with Polycarbonate.
If I use this code the repalce doesn't provide the correct results.
Me.RefracAdd = Replace(Me.RefracAdd, "polycarb", "Polycarbonate")
Me.RefracAdd = Replace(Me.RefracAdd, "poly", "Polycarbonate")
Is this possible?