Store RichTextBoxs content in Access

http://allenbrowne.com/Access2007.html
richTextBox == Memo fields, text boxes

but with access being a bit of an odd duck it could be that it only applys to a few versions and will likely not work in some...
Thanks a lot for your help. But i am confused a bit

The Memo fields only accept character. Is that possible to store image as well?

Best regards

I think RTF supports images so you can get the RTF from the rich text box (which is 8-bit text) and store it in the memo field.

RichTextBox has a property RTF which delivers the RTF for you to store in the database.

Darwen.

Hi Thanks for your reply
I have tried to store the rtf in the Access where the field type is Memo. It throw an exception that is the query is too complex. it happen when there is an image in the richtextbox content. Can you please tell me what should i do?

Once again thanks a lot

Are you trying to put the RTF string in the query string ?

e.g.

string query = string.Format("INSERT INTO MYTABLE (RTF) VALUES ('{0}')", _richTextBox.RTF);

This is very probably your problem.

You need to use parameterised queries e.g.

// assumes rich text box of _richTextBox
using (OdbcCommand command = new OdbcCommand("INSERT INTO MYTABLE (RTF) VALUES (@RTF)", _connection)
{
command.Parameters.AddWithValue("@RTF", _richTextBox.RTF);
command.ExecuteNonQuery();
}

As a side note you should be using parameterised queries all the time : they ensure that nomatter which database engine you're using the data is always formatted correctly for the database.

Darwen.