RTF and msaccess

I want to load an rtf file in a RichTextBox Control. The file should be stored in a msaccess database.
I made a table in an access database with one field, that is an OLE-field. Then I put in a rtf-file in this table. When I doubleclick this field in the database then MS-Word will be started. Now I've tried to load the rtf file from the database with Visual Basic in the Rich Text Box Control. I put an ADO-Control on a form, set the connection string and the Record Source. Then I set the DataSource of the RichTextBox Control to this ADO Control and I set the DataField property of the RichTextBox Control to the field in the database. When I start now the application, then something is loaded from the database, but I can't read it.
The text looks like this:


What Is my mistake? Is it possible to store a rtf file in a msaccess db an to load it in a RichTextBox Control?

Sorry for my english...!

Thank you very much!!!
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TimCotteeHead of Software ServicesCommented:
If you use the intrinsic data control with an OLE control then you can display rtf data from an access table.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
I think you need to store the rtf in a memo type field rather than the OLE. Change the Access Db field to memo and see what happens.
Use a memo field

Rtb1.TextRtf = "" & rs!memo

Also, the RTB control is not a fully functional RTF environment, tables and lines, for instance, are not supported. You can do basic editing and such, but that's about it.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.