special characters in search criteria

Paulsh · #1 (**permalink**) September 19th, 2005, 01:51 PM

I have some instances where I need to search for a particular value that has a special character in it. For example:
.findfirst AthleteName = "Rob O'Connell"

This returns an error. invalid syntax.

If I try to put square brackets [] around the field I get a different error - field name not valid

The following is the actual syntax used:-

rs.FindFirst "[AthleteName] = '" & Me![cboAthleteName] & "'"

Thanks for your help.

Paul

Steven · #2 (**permalink**) September 19th, 2005, 11:19 PM

This should fix your problem
rs.FindFirst "[AthleteName] = '" & Replace(Me.cboAthleteName, "'", "''") & "'"

I am a loud man with a very large hat. This means I am in charge

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
querystring and special characters	tulincim	Classic ASP Basics	4	October 4th, 2005 06:05 PM
storing special special characters in nvarchar...	ACE2084	SQL Server 2000	2	February 9th, 2005 11:45 AM
Substring and special characters	geordaa	XSLT	4	September 24th, 2004 02:27 AM
special characters	lian_a	Classic ASP Basics	3	June 23rd, 2004 05:16 AM