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

[RobDog888]

Usually we see this issue when dealing with a query to a db. To get around that we would just
double up on the single quote using the replace function.

strString = txtFirst & "," & txtLast
strString = Replace(strString, "'", "''")'

[Dave Sell]

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

To place (") in a String in VB, use (""). ie..

strText = "This ""String"" Contains double-quotes"

[vikram.bartakke]

Hi ppl,

Thank you very much for your help. It worked fine. I knew about this problem but the time when i actually implemented this application i was ignorant

Ignorance is not bliss always )

[RobDog888]

We were glad to have helped

Ps, dont forget to Resolve your thread