Adding line feeds and apostrophes to a database
I created a database in ACCESS of two fields, one a text field and the other a memo field. I can add to the database all right until I try to add a line feed or an apostrophe.
The code is:
SQL2 = "INSERT INTO tblSignData (nametbl, comtbl) VALUES ('" + myname + "',"
SQL2 = SQL2 + "'" + mycomment + "');"
Is there another way of writing this code so the LF and apostrohpes are accepted?