VB6 Rich Text Control

[algybrown]

I am trying to use the RichText control to save and load formatted text to a longtext field in a database (MySQL).

I seem to be able to save the text correctly using richtextbox1.textrtf (ie it looks like rtf text in the field when I view it generically)

ie:
db.execute "Insert into notices (Notice) values ('" & richtextbox1.textrtf & "'")

However when I read it back into a RichText control, I get the literal characters rather then the formatted text.

richtextbox1.textrtf = rs![notice]

Does anybody have any ideas how to resolve this or experience of using RichText controols in this way.

Cheers

Alan

 

[petermeachem]

RichTextBox1.SelRTF = whatever

http://www.accuflight.com

http://www.lettersdirect.co.uk

http://www.ourhouseinportugal.co.uk/

 

[HarleyQuinn]

peter - The only difference that would make is where the retrieved value is added?

algybrown - I would save the .TextRTF to a string before it goes to the database and then when you retrieve the value from the DB you can check to see if it's exactly the same as the one you intended to save. The reason I would ask you to do this is that I think the data must be getting changed somewhere between saving and retrieving from the MySQL DB.

I tried this with an Access DB and it worked fine for me.

Hope this helps

HarleyQuinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.