Recordset.Find names with apostrophes 1

[Sypher2]

I can't seem to do a SQL query or a recordset.find if a name has an apostrophe. Example:

rs.Find "Name='" & lstFullName.List(i) & "'"

If the name selected in the listbox has an apostrophe (O'Connor, O'Donald, etc.) then I get an error since there are a total of 3 apostrophes in the Find statement. Is there any way around this? I've tried using brackets to no success. Thanks.

 

[petermeachem]

if there aren't any " then you can surround the name with chr$(34) (which is &quot.

Or you can replace the single quote with a '' before doing the find. Peter Meachem
peter@accuflight.com

 

[Corkyballs]

See the folowing article on Technet for a full eaplanation of what you are trying to achieve.

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q178070

They actually use the name O'Brian as an example.

Have fun

Corkyballs

 

[Imhoteb]

Try this please

rs.Find "Name='"&Replace(lstFullName.List(i),"'","''&quot & "'"



This replaces all the single quate's in two single quotes

Good luck

 

[Sypher2]

Thanks! The Replace function worked perfectly. =)