Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Rich Text Format and HTML issues

    I have a Memo field in a table where I've specified the text format to be Rich Text. In reports, the contents of the field are displayed with HTML tags. I would like the text format of the field to remain Rich Text so that I can use tabs and carriage returns when entering data into this field and this to be reflected in my report.

    A pop up says that I can remove HTML encoding by using the PlainText function in an update query, but I cannot figure out how to do this.

    Any advice would be appreciated.



  2. #2
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    200
    Thanks
    0
    Thanked 31 Times in 30 Posts
    Quote Originally Posted by kerryg View Post
    I have a Memo field in a table where I've specified the text format to be Rich Text. In reports, the contents of the field are displayed with HTML tags. I would like the text format of the field to remain Rich Text so that I can use tabs and carriage returns when entering data into this field and this to be reflected in my report.

    A pop up says that I can remove HTML encoding by using the PlainText function in an update query, but I cannot figure out how to do this.

    Any advice would be appreciated.



    You must also tell the textbox control of forms and reports how you want it to display by setting the Text Format property to Rich Text not Plain Text. You will find this on the Property Sheet's Data tab.
    Last edited by HiTechCoach; 2015-03-24 at 13:12.
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    As Boyd said, you must set the control Text Format to "Rich Text".

    Actually, I don't think it matters that the field in the table is set to "Rich Text". Perhaps it matters only if you were entering data directly into a table. But if you are using a form, it doesn't seem to matter.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    200
    Thanks
    0
    Thanked 31 Times in 30 Posts
    Quote Originally Posted by MarkLiquorman View Post
    Actually, I don't think it matters that the field in the table is set to "Rich Text". Perhaps it matters only if you were entering data directly into a table. But if you are using a form, it doesn't seem to matter.
    The reason why you might also want to set it at the table level is when you drag fields from the field list onto a form or use a wizard then it will default the new control to have the Rich Text format property set.
    Last edited by HiTechCoach; 2015-03-29 at 18:21.
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

  5. #5
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts
    Thanks for the advice. I used your recommendations which all worked. I did, however find that the rtf formatting options such as bullets were quite limited.

  6. #6
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    200
    Thanks
    0
    Thanked 31 Times in 30 Posts
    Glad to here it is working now.

    Unfortunately the Rich Text formatting features are limited.
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

  7. #7
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    True, the Rich Text formatting features are somewhat limited, but I think it is still pretty useful. I guess that after all those years we finally are able to do things like underline a single word for emphasis made me not care about the short-comings!

    I suppose my biggest complaint is that I can't always make that menu bar display when I want it!
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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