Format Text in Memo Field

G

Gordon Padwick

I'm creating a database that contains scientific information and need to
have formatted text in a memo field. Specifically, I need to have subscripts
and superscripts to properly display chemical formulas. Also, some words
(scientific name of plants) should be italicized.
Is there any way to control the format of text in memo fields to accomplish
this?

Gordon
 
A

Allen Browne

The normal Access text box cannot format part of the text different than
other parts.

Stephen Lebans has a rich-text control available for download from
www.lebans.com
 
G

Gordon Padwick

Thanks for the suggestion, Allen.
I downloaded the RTF control from Stephen Lebans' site, and also downloaded
his samples. The control seems to accomplish what I need.
One problem is that Stephen's control requires raw RTF code. Although he
shows some samples of that code, he provides no information (as far as I
found) about how to write that code.
I found a Microsoft site that provides the RTF specification - all 200-plus
pages of it, but didn't feel like wading through all that.
I tried creating a file in Word and saving that in RTF format but was
dismayed at all the overhead code (as revealed when the file is opened in
NotePad)..
A fairly simple solution I found is to create the formatted text for a memo
field in WordPad, save that in RTF format, open the file in NotePad to
reveal the RTF code, save that code to the clipboard, and then copy to the
memo field in the Access database. That way, I could create the necessary
RTF code without being concerned about its structure.
Although the table I'm creating will contain several thousand records, the
memo fields in almost all of them have the same format, only the words are
different. That means I can create a master RTF memo field once, copy it
into all the records, and then just edit the text in each record.
Thanks for the help.

Gordon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top