471,350 Members | 1,629 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,350 software developers and data experts.

Inserting rich text into an MS Access memo field.

Hi, I'm desperately trying to figure out how to take rich-formatted text from
a rich text box and store it in a memo field (or any other type of field!) in
an Access database.

Can anyone help?? Cheers :)

--
Regards,
Ben Foster, ProDevel.
Feb 6 '06 #1
1 6518
Hi Ben

The Memo field can be used as a text field. To put the rich-formatted text
into memo field, you have to get the rich text first. Use RichTextBox.Rtf
to get it. It is a string and then you can create a OleDbCommand with
parameter to do the insertion. The memo field is mapped to
OleDbType.LongVarWChar. You can use it as the Parameter type.

You can check the following link for more information about parameters.

http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfsystemdataoledboledbparameterclasstopic.asp

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Feb 7 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by sling blade | last post: by
2 posts views Thread by bobdydd | last post: by
5 posts views Thread by ARC | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.