Question:
I’m trying to store text that’s in an RTF format using the TextRTF property of VB’s RichTextBox control. What type of field do I have to use in my table?
Answer:
The data in a rich text box actually is still text, but it contains tags for all the text formatting. So the rich text for a string that is bold, italic, underlined in Times Roman 14 point looks like this:
{ tf1ansideff0deftab720{fonttbl{f0fswiss MS Sans Serif;}
{f1fromanfcharset2 Symbol;}{f2fswiss MS Sans Serif;}
{f3fromanfprq2 Times New Roman;}}{colortbl ed0green0lue0;}deflang1033pardplainf3fs28iul Carpe diem.plainf2fs17 par }
Therefore, you can save data from a rich textbox to a SQL Server column with text data type. If you’re using ADO, the field type will be adLongVarChar.