How to handle string values containing apostrophes or quotes

[tad0075]

Hi all -
My db contains an unlinked form that is used to append records to 1-3 separate tables (tests to see if master records exists, appends if needed, moves on to child records). One of the fields is a text field meant for notes. The VBA errors out whenever this text contains apostrophes or quotes.

Is there a simple way to recall the string field with quotes and apostrophes intact and append it, or will I have to validate and remove them from the string?

Thanks,
Tyler

 

[jdraw]

see this article

 

[tad0075]

Perfect! I used Rule #2 instead of Rule #3 to delimit my embedded string, and it works great now.

 

[jdraw]

Glad you have it sorted.