I am having problem while inseting rtf document in a access database.I am using following code.
INSERT INTO DAIRY([TEXT])VALUES ('" & RICHTEXTBOX.RTF & "')"
BUT I GET AN ERROR SAYING LIKE THAT syntax error in query string
but when i replace it with richtextbox.text it works just fine.
Please Help me.
thanks

tmd

How about RichTextBox.TextRTF
This is the text including the rtf codes

Greetz

Tom.