[RESOLVED] Runtime Error 2147417848 (80010108) 'iRichtext '

[light3]

hi
When i try to get text from ACCESS table
this message show
why?

[DataMiser]

Show the related code where the error occurs in a post

[dilettante]

Why query for an updateable rowset when you only need to read the data?

In any case the database field contains what looks like a broken RTF fragment, not a complete RTF document or even a clean fragment. You can't assign an incomplete fragment to the RichTextBox.TextRTF property.

[dilettante]

I saw:

\pard \sb80 \sa40 \b0 \f1 \cf2 \'f5\u788?\'f0\'e5\'f1\'f9\u837?\u834?\'ef\'ed\cf0 \f0 \par \f3 hupero\u772?on\cf0 \f0 \par \i1 hoop-er-o'-on\cf0 \i0 \par Neuter of a derivative of {\cf11\ul G5228}; a \i1 higher\i0  part of the house, that is, apartment in the \i1 third\i0  \i1 story:\i0  - upper chamber (room).\par

This has a lot of flaws, but the main problem might be the .\par at the end or those \uxxx? tokens.

[light3]

I think that this format saved to word Document(*.doc) not Rich text format(*.rtf)
How get the text without formatting
this is text

ὑπερῷον
huperōon
hoop-er-o'-on
Neuter of a derivative of G5228; a higher part of the house, that is, apartment in the third story: - upper chamber (room).

thanks

[dilettante]

No, it is definitely RTF.

Well you have to wrap the fragment, e.g.:

Option Explicit

Private Const RTF As String = _
      "\pard \sb80 \sa40 \b0 \f1 \cf2 \'f5\u788?\'f0\'e5\'f1\'f9\u837?\u834?" _
    & "\'ef\'ed\cf0 \f0 \par \f3 hupero\u772?on\cf0 \f0 \par \i1 hoop-er-o'-on" _
    & "\cf0 \i0 \par Neuter of a derivative of {\cf11\ul G5228}; a \i1 higher" _
    & "\i0  part of the house, that is, apartment in the \i1 third\i0  \i1 story:" _
    & "\i0  - upper chamber (room).\par"

Private Sub Command1_Click()
    RichTextBox1.TextRTF = "{\rtf1" & RTF & "}"
End Sub

[light3]

thanks dilettante
it work

[light3]

Is there a way to show the Hebrew words (ὑπερῷον) in richtextbox
instead of (õ̔ðåñù͂ͅïí) ?
i used this code but not work
http://www.vbforums.com/attachment.p...1&d=1269106217