First of all, this is not my database design choice, it's just what I have to deal with....
The DB guy designed a table which has a field with a default value of 'No' (single quotes include). It's a textfield.
I am creating a form to input data into that table. I want the textbox that is associated with the above mentioned field to have its default value as 'No' (single quotes included). If I just type 'No' in the properties box for the text box, it removes the single quote when I view my Form in Form View.
ALSO, I then need to make my code below create a SQL query that will not have an error in it when inserting a string with a single quote in it.
Thanks