Solved

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

Posted on 2012-03-22
4
520 Views
Last Modified: 2012-04-07
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
Comment
Question by:hintco
  • 2
  • 2
4 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 37753823
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
 
LVL 1

Accepted Solution

by:
hintco earned 0 total points
ID: 37799799
i know the answer by myself thanks u very much.
0
 
LVL 77

Expert Comment

by:peter57r
ID: 37799884
Please post your solution so that others may benefit.
0
 
LVL 1

Author Closing Comment

by:hintco
ID: 37818759
There isn't any good solution and there isn't much solutions.
I get the solution by myself
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question