special characters in a string
Posted on 2000-03-13
This should be an extremely easy problem, but vb is not my primary language.
How do you pass special characters like single and double quotes in a string. Specifically this is in VBA and I am using the following function:
rst.FindFirst ("field = '" & strSearch & "')
Only strSearch could contain a single quote, which will cause an error in the function. It takes the single quote as the end of the string to be searched for.
Thankyou in advance for any help.