Hello,

I am having a problem to have the formatting of my rich Text Box in a Form to be retained when I do an Insert Into Sql Statement.

The text in the RTB is saved in the Access Database but alle the Bold Face, Underline, etc... is lost when I call back the saved text from the database.

Any solution to help me with this problem?

Mark

I assume you are using something like:

[column1] = RichTextBox1.Text

Try:

[column1] = RichTextBox1.Rtf

Sorry, that was for VB.Net. I don't use VB6 very much but I think the code would look like this:

[column1] = RichTextBox1.TextRTF

J

Putting it is just an insert into Table (Column) Values (RichtextBoxNotes.TextRtf)


Pulling the data is done like this:

Set FormBonCommande.RichTextBoxNotes.DataSource = RsTitre2
FormBonCommande.RichTextBoxNotes.DataField = "Description"

FormBonCommande.RichTextBoxNotes.TextRTF = RsTitre2.Fields("Description").Value

This still does not work.

I think I might have found a solution. I can use the MEMO field instead of OLE Object in the database or Plain TExt to retain the format of the RichTextBox.

However with MEMO I am limited with 65,000 characters in the RTB.

Thanks for your advices and if you get anything better let me know.

Mark