Search variable with ' character

[codo]

I want to search a record where the value containing ' character, but it result an error. Here's the example

FindText = "Joy's car"
With rs_temp
.MoveFirst
.Find "item = '" & UCase(FindText) & "'"
end with

but if i change the FindText = "Joys car" the code running with no errors.

How can i search record that contain ' character ?

 

[SBerthold]

Double up on the single quote (use two single quotes -NOT a double quote):

"Joy''s car"
or
"Joy" & chr$(39) & chr$(39) & "s car"

You can achieve this simply by using the VBA Replace() function.

 

[abaldwin]

Use the replace function on your variable
i.e.

FindText = "Joy's car"
findtext = replace(FindText,"'", "''")

granted this could be done in one line but I broke it into two lines to demonstrate the replace function.



Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

 

[SBerthold]

Wow, still echoing after 6 hours