I'm new to vba - using it with access. I'm building sql statements on the fly. Sometimes the dynamic text has a ' (quote) in it (O'Toole). How do I escape that out in vba. I looked for a substring command, didn't find it. I'm using access 2000 and its vb.