Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Indiana, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formatted memo field (Access 97/SR2)

    Paradox allowed you to format the text in a memo field. It had a specific field type called Formatted Memo. It does not appear that Access 97 allows you to format the text. Specifically, it will not show Bold and Italic font in the field. I can't underline individual words, either. We may be out of luck.

    Thanks.

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Mishawaka, Indiana, USA
    Posts
    145
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatted memo field (Access 97/SR2)

    The company FMS has an add-in that allows you to use formatted text in memo fields.

    http://www.fmsinc.com/

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Indiana, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatted memo field (Access 97/SR2)

    Thanks, Tom. I will check into it.

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Formatted memo field (Access 97/SR2)

    Microsoft also has a Rich Text control that lets you work with formatted text in a memo field. You should be able to find it referenced in the Knowledge base, and it was a freebie the last time I checked.
    Wendell

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Indiana, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatted memo field (Access 97/SR2)

    Thanks to you, too.

  6. #6
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Indiana, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatted memo field (Access 97/SR2)

    I looked in the Knowledge Base and could not find anything like you mentioned. Do you have an idea of where it might be?

  7. #7
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatted memo field (Access 97/SR2)

    The "More Controls" tool in your form design toolbox should include a "Microsoft Rich Textbox Control, version 6.0" ActiveX control. You can bind it to the memo field through its Control Source property.

    I haven't used it myself, although I did just try it out -- it seems to display RTF text nicely (and this text is retained in your memo field), but I haven't figured out a way to format the text from within the form field (I pasted some RTF text into the field to try it out).

    Anyone... Anyone...

    Hope this helps.

  8. #8
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Formatted memo field (Access 97/SR2)

    I just realized you are using Access97. I believe the RTF Textbox ActiveX control was distributed through the Office97 Developer edition. I think maybe it came with Visual Basic also, but I'm not sure. There are licensing issues to be considered too - presumably you need to own one of those products to work with it. The FMS version of an RTF control is focused on 2000 - with ActiveX that may or may not be an issue. One other alternative is to use Word as your editor and store your text in a Word doc as an OLE object. They tend to be pretty cumbersome to work with however.
    Wendell

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Formatted memo field (Access 97/SR2)

    Personally, I don't like rich text controls or attempting to format memo fields. Access is a database program, not a text editor. Yes, there are controls you can add in that will let you do this, but formatting is NOT data. If you add that kind of control, you also pay a penalty in application size, complexity of maintenance and performance.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •