[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 562
  • Last Modified:

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.
0
hintco
Asked:
hintco
  • 2
  • 2
1 Solution
 
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
 
hintcoAuthor Commented:
i know the answer by myself thanks u very much.
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

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now