Can someone tell me how I would replace a ' in my text field. If I try to update the field it screws up my query! The code I thought I mite use would be something like; (strMessage being my text field name)
If InStr(strMessage, "'") = 1 Then
Me("strMessage").Value = Replace(strMessage, "'", " ")
Woudl this work?