Change text of 1 word in a text box

message from Scott on 23 May 2004
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
 
fredg replied to Scott on 24 May 2004
If you have Access 2000 or newer you can use the Replace Function.
Replace([FieldName],"Reside","Resides")
 

Archived message: Change text of 1 word in a text box (Microsoft Access Forms)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.