Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2012-03-22
4
Medium Priority
?
547 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

618 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