Textarea prob, Access bug

[pixiesfb]

Trying to submit a textearea to Access DB. When put a string with any quotes in the textarea and submit/update, string gets chopped off at the quote. Was told to do a replace #replace(question, """","""""", "ALL&quot#, but does not seem to work. Help!

 

[tlhawkins]

Hey,

The above #replace(... function is going to try to put 2 " for every one in your text. You can attempt that manually, just enter text with "" instead of " and see if it works, sometimes it does.

I would try variations like this if so:

#replace(question, '""','""""', "ALL&quot#

Or what might work even better is to find the CHR # for a " then use that for the replacing one with two.

If you find what that chr # is please post it I keep loosing it.

Hope it helps.

 

[pixiesfb]

#replace(question, "",""", "ALL&quot#

This is still not working. This has to be a common problem!!

 

[pixiesfb]

fixed with:

#replace(question, """" ,"&##034", "ALL&quot#

Thanks. Took me long enough!!

 

[tlhawkins]

thanks for posting the solution.

I think each time we encounter it everyone fights through it and then forgets how.

 

[tleish]

I don't get it, I've tested this with my Access DB and I can put in quotes from a textarea just fine without any special formatting or escaping the quotes.

What exactly is it that you are doing that causes the string to be shortened at the quote? How can I douplicate this problem? I know you've solved the problem, I'm just curious how you it became one in the first place.
- tleish