How to Use Rich Text Formatting in your Microsoft Access Forms & Reports. Color, Fonts, Bold, More!

Поделиться
HTML-код
  • Опубликовано: 1 авг 2024
  • In this video, I'm going to show you how to use Rich Text Formatting in your Microsoft Access forms and reports. We'll take the Letter Writer database from a previous TechHelp video and convert it to Rich Text so we can change colors, fonts, add bold, underline, and more.
    Heath from Price, Utah (a Platinum Member) asks: I'm using your Letter Writer database from a previous TechHelp to send correspondence to my customers. It's very useful. Thank you. Is there any way I can add formatted text to the report, kind of like how you can format text in Microsoft Word? It would be nice to add some color, change the font, bold, and things like that.
    Silver Members and up get access to an Extended Cut of this video.
    Members will learn how to strip out any rich text formatting (RTF) or HTML tags from the rich text field if you want to send just the plain text to someone, export it, etc. PLUS you'll have access to the original video's Extended Cut too where we develop the ability to load pre-made letter templates complete with mail merge codes.
    MEMBERS VIDEO:
    • Rich Text Formatting i...
    BECOME A MEMBER:
    RUclips: / @599cd
    or My Site: 599cd.com/THMember
    LEARN MORE:
    599cd.com/RichText
    LINKS:
    Letter Writer TechHelp: 599cd.com/LetterWriter
    Access Expert 5: 599cd.com/ACX5
    Access Expert 6: 599cd.com/ACX6
    COURSES:
    FREE Access Beginner Level 1: 599cd.com/Free1
    $1 Access Level 2: 599cd.com/1Dollar
    FREE TEMPLATE DOWNLOADS:
    TechHelp Free Templates: 599cd.com/THFree
    Blank Template: 599cd.com/Blank
    Contact Management: 599cd.com/Contacts
    Order Entry & Invoicing: 599cd.com/Invoicing
    More Access Templates: 599cd.com/AccessTemplates
    ADDITIONAL RESOURCES:
    Donate to my Tip Jar: 599cd.com/TipJar
    Get on my Mailing List: 599cd.com/YTML
    Contact Me: 599cd.com/Contact
    TechHelp: 599cd.com/TechHelp
    Consulting Help: 599cd.com/DevNet
    Twitter: / learningaccess
    en.wikipedia.org/wiki/Microso...
    products.office.com/en-us/access
    microsoft.com/en-us/microsoft...
    KEYWORDS:
    rich text, RTF, HTML tags, microsoft word, formatted text, plain text, plaintext, create a rich text field, RichText, TextFormat, text format, adding rich text formatting, access rich text, work with rich text, wysiwyg, rich text editor, rich text html, format text in textbox, bold, italics, underline, color, font
    QUESTIONS:
    Please feel free to post your questions or comments below. Thanks.

Комментарии • 20

  • @paulinemaurice9189
    @paulinemaurice9189 10 месяцев назад

    This rock! Thanks so much!!!

  • @EngArkad
    @EngArkad 2 года назад

    Thanks Lucturer 🖐

    • @599CD
      @599CD  2 года назад

      Welcome

  • @ZurelaXXI
    @ZurelaXXI Год назад

    Hi, how can i adjust my line spacing on a Rich Text Textbox and im using expression builder

    • @599CD
      @599CD  Год назад +1

      Not possible

  • @hs7981
    @hs7981 Год назад

    I am importing a file from excel to Access in a table, one of the fields is text in excel and rich text in Access. Because of difference in text format, I am unable to see some of the “/“ in the excel file in Access. How do I fix it?

    • @599CD
      @599CD  Год назад +1

      599cd.com/ask

  • @chrisdosado9404
    @chrisdosado9404 2 года назад

    Hi, how do we eliminate the error 3075 caused by an apostrophe in a string when running DoCmd.RunSQL ? Appreciate if you can give answers to this. Thanks in advance

    • @599CD
      @599CD  2 года назад

      Replace it with a double-single-quote.
      S = Replace(S,"'","''")

    • @599CD
      @599CD  2 года назад

      599cd.com/Replace

  • @jackgray4777
    @jackgray4777 2 года назад

    Can you please post about reports and queries

    • @599CD
      @599CD  2 года назад +1

      I've got lots of videos on reports and queries. Go to my web site and search for what you're looking for. 599cd.com/Search

  • @likepc9191
    @likepc9191 2 года назад

    how to use rich text in combobox! help me please, Thanks you

    • @599CD
      @599CD  2 года назад +1

      Can't do it. Plain text only. You'll have to use a subform.

    • @likepc9191
      @likepc9191 2 года назад

      @@599CD thanks you

  • @abdulrehmanmughal8235
    @abdulrehmanmughal8235 2 года назад

    can we add image r pic in tex box!

    • @599CD
      @599CD  2 года назад +1

      You can't put an image INSIDE a textbox, but you can associate images with the record and print them in a report if needed. See 599cd.com/Images

    • @abdulrehmanmughal8235
      @abdulrehmanmughal8235 2 года назад

      @@599CD i want to send email that includes images and some body text so how we create it ?

  • @vayr880
    @vayr880 2 года назад

    Is this guy Khan Academy?

    • @599CD
      @599CD  2 года назад

      Haha. Nope.