How to work with rich text in Access 2007 and 2010

True rich text wasn't supported in Access 2003 (and earlier versions). Access 2007 and 2010 both support rich text and it's easy to implement.

In the .mdb versions of Access, working with rich text wasn't impossible, but it certainly wasn't easy. With some slick VBA code or a third-party control you could get it, but it was a lot of work. Access 2007 and 2010 now support easy-to-implement rich text formatting, but only in memo fields.

Rich text means formatted text, but a bit more. Specifically, earlier versions don't allow you to single out a specific word or character within an entry for different formatting. It was all or nothing. Behind the scenes, Access is actually using HTML - something that probably won't matter to most users, but might matter to SharePoint and database developers and anyone upgrading an .mdb database to the .accdb format. Using Access 2010, let's take a quick look at how to apply the rich text setting:

  1. Add a memo field to a table.
  2. In the Field Properties pane, choose Rich Text from the Text Format properties dropdown list.
  3. Save the table.

The Text Format property is new and Plain Text is the default setting. A bound control will inherit this property. If you change the property at the table level, the bound control will not update accordingly. You must change that control manually. Once you switch back to plain text, the control will display text and HTML tags for existing entries. Implementing the new support for rich text couldn't be simpler. Simply enter the text and format it as you would in Word. For example, after entering text in the bound text box control, select a few characters or words. Then, using the available options in the Text Formatting group, format away! The entry below contains italics and bold. When upgrading an .mdb version database that uses a third-party rich text control or VBA code to support rich text, you might run into a snag. As I mentioned, the rich text support is HTML, not Rich Text Format (RTF). Trying to display previously stored RTF encoded text in the new rich text control won't work. If you must convert, you'll have to reapply the HTML tags.