[nuchy]

Hello All,

I want to have the single quote in my data field but I can't be insert into the table field. I tried many ways to use it by put '\', '&' and "" in front of single quote but it didn't work!
Help please!

[Emmanuel]

Hi,

For example if you want only one single quote as value in your datafield, try one single quote between two double quote :

NameOfRecordset.fields("NameOfDataField").value = "'"

Note that in general, the string combinations are the same with a textbox object. You can put it one on your form to see the result before to use your code on a field database.

[nuchy]

let me give you some of my example.
my data -> 7' wood stick
so, I want to have exactly like the data above for my database field.
I tried to do this
Mid(mystring, myposition) = "'", but it still didn't work.

Any Idea?

Thanks..

Originally Posted by Emmanuel

Hi,

For example if you want only one single quote as value in your datafield, try one single quote between two double quote :

NameOfRecordset.fields("NameOfDataField").value = "'"

Note that in general, the string combinations are the same with a textbox object. You can put it one on your form to see the result before to use your code on a field database.

[hoopaddict]

Mid(mystring, myposition) = "'", but it still didn't work.

how about Mid(mystring, myposition) = chr(39)?

[Emmanuel]

Hi all,


If you declare mystring as string or as a variant, it works and chr(39) too. Use a temporary string variable in mid expression and then assign the datafield value with it.

[hyjacked]

have you tried 2 single quotes? for some reason I'm thinking that is how it is done.