Question about memo to OLE data type conversion in a table

  • Thread starter Thread starter sduraybito
  • Start date Start date
S

sduraybito

Hi,

I have an existing memo field in a table that contain paragraphs of
text. When I convert this field to an OLE field, the field shows "Long
binary data" in each record and when I click on a record I get the
following error message:


"A problem occured while Microsoft Office Access was communicating with
the OLE server or ActiveX control."

"Close the OLE server and restart it outside of Microsoft Office
Access. Then try the original operation again in Microsoft Office
Access."


When I generate a report from this table, the paragraph of text I had
in the memo field appears OK but it is right-justified.

When I convert the OLE field back to a memo field, the paragraph
appears in the table as before, like I did nothing.

1. Is this normal behavior? Where is the text that makes up the OLE
record stored?
2. Is there a way I can edit the converted OLE field (for example,
left-justify the text)?

Thanks,

Peter
 
Why would you convert a Memo field to an OLE field type?
Why do you need to?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
I wan to apply formatting to the text such as bold, tab, etc.
Click to expand...

You would still use a memo field, but you have to use a third party control to
display the contents as Rich Text instead of normal text. When doing that you
not only store the text in the field, but all of the Rich Text formatting tags
as well. This means of course that ONLY a Rich Text control will be able to
display the data as any normal control will display all of the formatting tags
and it will look like gibberish.

Create a small file with WordPad and apply some text formatting. Then save the
file and open it with NotePad and you will see what your saved text will look
like.
 
Thanks for the link.

My question remains, though, where does the text get stored when I
convert from an existing memo field with text in it to an OLE field? I
can convert back and no damage done, so while it's an OLE field the
text must exist somehwere.

Peter
 
Thanks for the link.

My question remains, though, where does the text get stored when I
convert from an existing memo field with text in it to an OLE field? I
can convert back and no damage done, so while it's an OLE field the
text must exist somehwere.

Peter
Click to expand...

I would imagine that it is in the OLE field but being handled differently by
the GUI.
 
I downloaded RTF2 Active control, version 1.8 and can get the demo to
work but caanot make it work on my database. Is there a registration
fee?
 
The control is FREE.
TO work in your MDB you would have to insert the RTF2 ActiveX control
onto your own Form(s) and bind the control to your form's Datasource
just as you would a TextBox control.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Thanks. I think I kind of have it working. I had to open VBE and import
clsRFTToolbar and modRFT2ToolBar. Is this normal procedure? Also, I
still don't get RFT2 as an option under View>Toolbars and I don't see
the little RFT window pop out when I open a form. Should I reinstall?

Thanks,

Peter
 
If you want the ToollBar then you have to IMPORT it from my sample MDB.

RIght click on any blank area of the main database window
Select Import from the popup menu
In the Import Object window click on the Options>> button
Select Menus and ToolBars

You do realize that the RTF2 control has a built in Menu, just right
click anywhere within the control and it will popup.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Yes, I see it now. Thanks.

I posed another question as a new topic as it would probably make it
easier for othe users to search and find. It concerns using the
resizing code in a subreport.

Peter
 
Back
Top