Re: Format Text in Memo Field

From: Gordon Padwick (gpadwick_at_earthlink.net)
Date: 03/14/04


Date: Sun, 14 Mar 2004 06:22:38 GMT

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

"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
news:405084f5$0$22510$5a62ac22@freenews.iinet.net.au...
> 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
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Gordon Padwick" <gpadwick@earthlink.net> wrote in message
> news:UFT3c.14499$%06.12626@newsread2.news.pas.earthlink.net...
> > 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?
>
>



Relevant Pages

  • Re: Hanging indent via Rich Text Control?
    ... The control can either be Unbound or Bound to a single Memo field, ... you would have to programmatically add the necessary RTF encoding ... >> Stephen Lebans ...
    (microsoft.public.access.reports)
  • Re: RTF2 Runtime Confusion
    ... Off the top of my head your RTF header is wrong. ... >> 3) If you bind the Control to the table containing the RTF data you ... >>> text on my report in a special text situation. ... >>> into the report in the On Format event for the detail section. ...
    (microsoft.public.access.forms)
  • Re: Concatenated text and Lebans Rich Text Control
    ... I'm not adding a line return when I insert the RTF text. ... RTF text inserted via the SelTextRTF method, into a blank control? ... Dim strColor As String ... Microsoft's integrated rich text control is pretty much useless if you ...
    (microsoft.public.access.forms)
  • Re: open a Works file attached to email with Word
    ... RTF is the most compatible file format between the Word and Works ... Paul Ballou ... Control the things you can and Don't Worry about the things you can't ...
    (microsoft.public.office.misc)
  • Re: RTF Control not displaying data
    ... jsut as a normal TextBox control that is bound to a Memo field. ... Is using/loading the RTF toolbar the only way to allow the user to change ... "Stephen Lebans" wrote: ...
    (microsoft.public.access.forms)