Usually we see this issue when dealing with a query to a db. To get around that we would just
double up on the single quote using the replace function.
VB Code:
  1. strString = txtFirst & "," & txtLast

  2. strString = Replace(strString, "'", "''")'