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

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.
LVL 1
hintcoAsked:
Who is Participating?
 
hintcoConnect With a Mentor Author Commented:
i know the answer by myself thanks u very much.
0
 
peter57rCommented:
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
0
 
peter57rCommented:
Please post your solution so that others may benefit.
0
 
hintcoAuthor Commented:
There isn't any good solution and there isn't much solutions.
I get the solution by myself
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.