For Some reason I carn't insert the RichTextBox source into a Database

[a_jam_sandwich]

For Some reason I carnt insert the RichTextBox source into a Database

Anyone else know of this?????

Using OLE namespace Access 2002 database

And the Code for insert as following

[VB]
SQLCommand.CommandText = "INSERT INTO DOCUMENTS (Content) VALUES (" & p_DocumentEditor.DocumentRTF.Rtf & ")"
[/VB]

Any Ideas?

Thx

Andy

 

[a_jam_sandwich]

Ive been messing around with it now and it seems its missing the second

The same happens when showing it in a message box e.g

[VB]
msgbox("" & MyRichTextBox.Rtf & "")
[/VB]

The Second Does no show

Is it somthing to do with the encoding? or Invalid invisable charaters

This is beyond a problem this is a critical part of the program

Andy

 

[a_jam_sandwich]

Found out the last charater in the .Rtf string is a charater that stops changes on the end of the string by simply removing this charater it now works

Andy