Resolved--String manipulation in VBA

[vikram.bartakke]

Hi ppl,

I have following situation. I have a form containing First name text box and the last name text box. When I press confirm button on this form, it concatenated First name and the last name to give me full name as a parameter that I am passing to the next form. However, problem comes if a user has last name like "O'Neil" or "O'Hair" or "O'Dell" the compiler does not understandd that apostrohy sign and gives me a runtime error.

Does anyone know how do I access such string which contains characters such as " " " , " ' ", "`"

Thanks in advance,
Vikram Bartakke