For any SQL text field being used in a statement always use the following:
Code:
myFielddata = Replace(myFielddata, "'", "''")