I've tried this function in a BeforeUpdate event and an AfterUpdate event and I get a compile error that says "Expected: =". My code is:
Replace(CustItemNumberTxt,"'","")
CustItemNumberTxt is the textbox on my current form that holds the string I am searching.
I've also tried:
Replace(CustItemNumberTxt,chr(39),"")
I'm trying to edit single quotes (apostrophes) from my text.