I know that this has had to come up before. Is there a safe way of determining that a string (like a last name) includes a " ' "? This, I know, will become a problem when logging in employees to my Access 2000 table.

Any suggestions?