You can store rich, formatted text in an Access database by using a Long Text (also called Memo) field and setting the field's TextFormat property to RichText. For example, you can make the text bold or underlined, apply different fonts to individual words or characters, and change text colors. You can apply formatting to all or part of the contents of the field when the field is displayed in a datasheet and by editing the field through a bound control in a form or report.

In this article

What is rich text?

Rich text is text that is formatted with common formatting options, such as bold and italics, that are unavailable with plain text. You format your data by using common formatting tools, such as the Ribbon and the Mini Toolbar. Behind the scenes, Access applies Hypertext Markup Language (HTML) formatting code to your data. Access uses HTML because it provides a greater degree of compatibility with rich-text fields stored in SharePoint lists.

Access Ribbon Image

Access stores rich text by using the Long Text data type, which is the only data type that has built-in support for rich text. To create a field for storing rich text, you create a Long Text field and then set that field's TextFormat property to RichText. The two possible values are:

  • RichText    Enables rich text and is stored and interpreted as rich HTML markup.

  • PlainText    Enables plain text and is interpreted as plain text.

You set the TextFormat property for the Long Text field in table in Datasheet View and Design View. After you store rich text in a Long Text field, you can display it in a form or report by using a text box control. The text box control has a TextFormat property that inherits its initial value from the TextFormat property of the Long Text field. However, you can change the TextFormat property on the text box control.

The following table shows supported rich text formatting options:

Icon

Option

Description

Button image

Font name

Selects a different typeface.

Button image

Font size

Selects a font size.

Button image

Bold

Makes the selected text bold. If the text is already bold, removes the bold.

Button image

Italic

Makes the selected text italic. If the text is already italic, removes the italic.

Button image

Underline

Makes the text underlined. If the text is already underlined, removes the underline.

Align left

Aligns the text against the left margin.

Center

Centers the text within the margin.

Align right

Aligns the text against the right margin.

Button image

Numbering

Begins numbering paragraphs. The number appears prior to each paragraph.

Bullets button image

Bullets

Begins placing a bullet before each paragraph.

Button image

Font color

Selects a font foreground color.

Button image

Text highlight color

Makes text look like it was marked with a highlighter pen.

Button image

Decrease indent

Decreases the paragraph indentation.

Button image

Increase indent

Increases the paragraph indentation.

Left to right button image

Left-to-right

Fills control from left to right.

Right to left button image

Right-to-left

Fills control from right to left.

Top of Page

Create a rich text field

You can create a rich text field in table Datasheet View or Design View.

In Datasheet View

  1. Open the table in Datasheet View.

  2. Select Click to Add, and then select Long Text from the list.

  3. Double click the field header and enter a meaningful name for the new field.

  4. Save your changes.

In Design View

  1. Open the table in Design View.

  2. In the table design grid, locate the first empty row. Then, in the Field Name column, type a field name.

  3. In the Data Type column, select Long Text.

  4. Under Field Properties, click the General tab.

  5. Click inside the Text Format box and select Rich Text.

  6. Save your changes.

Top of Page

Change a field to rich text

  1. Open the table that contains the field in Design View.

  2. In the table design grid, click the Long Text field that you want to change to rich text.

  3. Under Field Properties, click the General tab.

  4. Click the Text Format box and select Rich Text.

  5. Save your changes.

Top of Page

Change a rich text field to plain text

Important    When you change a field from rich text to plain text, Access prompts you with a warning that all formatting will be removed. After you have applied the change to plain text and the table has been saved, you cannot undo the change.

  1. Open the table that contains the field in Design View.

  2. In the table design grid, click the Long Text field that you want to change to rich text.

  3. Under Field Properties, click the General tab.

  4. Click in the TextFormat box and select Plain Text.

  5. Save your changes.

Top of Page

Clear the Append Only property

To enable rich text formatting for a field, ensure that the Append Only property for the field is disabled. Otherwise, Access hides the text in the field whenever you place your cursor in that field, or in any form or report controls bound to that field.

To disable the Append Only property

  1. Open the table in Design View.

  2. Select the Long Text field that you want to change, and in the lower part of the table designer, on the General tab, scroll down to the Append Only property.

  3. Click the field next to the property and select No from the list.

  4. Save your changes.

Top of Page

Enable rich text formatting for form and report controls

If you use the commands on the Create tab to create a form or report, and you have enabled rich-text editing for the underlying Long Text field, the resulting text box control inherits the Text Format property set for the Long Text field. If you have data in the Long Text field of your table, that data appears in the text control on your form or report. However, Access does not enable rich text editing when you manually add a control to a form or report, even if you subsequently bind that control to a Long Text field with rich text formatting.

  1. Open the form in Design View.

  2. On the Design tab, in the Controls group, click Text Box.

  3. In a blank area of your form, click and drag your mouse to draw the control.

  4. Click the text area of the new control, right-click the text area of the control (not the label), and then click Properties.

  5. In the property sheet for the new control, click the All tab.

  6. Click the Control Source property box and select your Long Text field from the list.

    By default, the list shows the fields in the table that is bound to your form. If your Long Text field resides in another table, use this expression syntax to bind the control: =[table name]![field name]. Use the brackets and exclamation point exactly as shown. Type the name of your table in the first part of the expression, and the name of your Long Text field in the second part. For example, if you have a table named Notes with a Long Text field named Compliments, you would enter this string in the Control Source property box: =[Notes]![Compliments]

  7. In the property sheet, with the All tab still selected, locate and select the Text Format property box, and then select Rich Text from the list.

  8. Save your changes.

Top of Page

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.