Storing RTF Text

Storing RTF Text

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?

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.

See also  How AI Art Generators Can Save Time and Money for Startups

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist