Special characters in Default Value and Query

[blacksaibot]

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

[blacksaibot]

this is the error I get when running my insert code after clicking the submit button

Run-time error '3705':
Syntax error (missing operator) in query expression "'No'".

This is the code that's used to grab the value in my query:

queryStr = "INSERT INTO [t_User_Ldr_Info] VALUES(" & _
"'" & dag_rfi & "', " & _

'....and some more code down here to finish the query

should there be another way I grab the text from my textbox named dag_rfi (whose value is 'No')??