<div>
There is no SQL command to do this.<br />
<br />
In DAO it can be done like.. (but I can't help you with the .net code)<br />
.<br />
Dim mytdf as dao.tabledef<br />
Dim prp as DAO.Property <br />
set mytdf = currentdb.tabledefs(&quot;table<wbr />name&quot;)<br />
<br />
With myTDF.Fields(&quot;memofieldnam<wbr />e&quot;) <br />
Set prp = .CreateProperty(&quot;TextForma<wbr />t&quot;, dbByte, acTextFormatHTMLRichText) &nbsp;<br />
&nbsp;.Properties.Append prp <br />
End With
</div>


There is no SQL command to do this.

In DAO it can be done like.. (but I can't help you with the .net code)
.
Dim mytdf as dao.tabledef
Dim prp as DAO.Property
set mytdf = currentdb.tabledefs("tablename")

With myTDF.Fields("memofieldname")
Set prp = .CreateProperty("TextFormat", dbByte, acTextFormatHTMLRichText)  
 .Properties.Append prp
End With

<div>
Please post your solution so that others may benefit.
</div>


Please post your solution so that others may benefit.

<div>
There isn't any good solution and there isn't much solutions.<br />
I get the solution by myself
</div>


There isn't any good solution and there isn't much solutions.
I get the solution by myself

<div>
<div class="content wysiwyg-content">
I want to create atable in ms access database that include memo column , and this column has &nbsp;rich text property &nbsp;not plain text.<br />
i want it through sql code. Because i will use it in vb.net to create tabels automatically.<br />
When Im creating table and make memo, it became as paln text by default not rich text.
</div>
</div>


I want to create atable in ms access database that include memo column , and this column has  rich text property  not plain text.
i want it through sql code. Because i will use it in vb.net to create tabels automatically.
When Im creating table and make memo, it became as paln text by default not rich text.

How to creat ms access table with memo colmun rich text property by sql code?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.