Search code examples
vb.netrtfcreate-tablealter-table

add rtf to MS Access field during CREATE TABLE in vb.net

From my VB.net application I manage to create a database. I can also create tables, with all kinds of datatypes in them. (with much thanks to stackoverflow's contributors!) so far so good... but how do I set the datatype MEMO to accept rich text?

basically how do I code to get : (MS Access snippet)

enter image description here

I'm sure it is a simple addition to the regular CREATE TABLE business - but I don't know what!

any hints would be most appreciated!

Solution

  • You don't have to do anything to make the Memo data type accept RTF data. RTF is text and a Memo column stores text. Job done. Many of those fields you're setting on the column are about how Access DISPLAYS the data within Access itself, not how it stores it. If you're using the MDB or ACCDB file simply as storage and the data only gets displayed in your application then that Text Format is irrelevant.