Change text of 1 word in a text box

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

Is there any way how to update one word in a text box to
another. ? For example, I want to change the
word "Reside" in a text box to the word "Resides", so
that every "Reside" will become "Resides" but it will not
affect any other text in the field. ?


Thanks


Scott
 
Is there any way how to update one word in a text box to
another. ? For example, I want to change the
word "Reside" in a text box to the word "Resides", so
that every "Reside" will become "Resides" but it will not
affect any other text in the field. ?

Thanks

Scott
Click to expand...

If you have Access 2000 or newer you can use the Replace Function.
Replace([FieldName],"Reside","Resides")
 
Back
Top