Syntax to Include Apostrophe?

[jt463]

What is the proper syntax for the criteria to include a name with an apostrophe?

Name: Swanson's Farm

Criteria:

Subdivision = ''Swanson's Farm''

That code keeps blowing up on me. I have tried ""Swanson's Farm"" and a number of combinations of apostrophes and quotes but can't seem to figure out the correct combination.

Thanks in advance.

 

[jt463]

I figured it out:

Subdivision = ""Swanson's Farm""

 

[PHV]

My way:[tt]
someValue = "Swanson's Farm"
criteria = "Subdivision = '" & Replace(someValue, "'", "''") & "'"[/tt]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886