I have a large form (about 20 fields) in which to update and insert new recordsets. The database is not accepting the apostrophe value as part of a string.
I am familiar with the code:
where "value" was the only possible property to be updated in a table.
But my question is:
Do I need to insert this line of code for each individual textbox and textarea on my update and insert forms?
I am familiar with the code:
Code:
Value = replace(value,"'","''")
But my question is:
Do I need to insert this line of code for each individual textbox and textarea on my update and insert forms?