Access 2007 FAQ
How do you set up a field to accept Rich Text in Access 2007?
Access 2007 now supports Rich Text in Memo data types. Go into Table Design view for your table and set your data type to Memo. Now look at the Field Property Sheet for this field and you'll see an option called Text Format. This property has two options - Plain Text and Rich Text. Select the Rich Text option, as seen in the following screenshot, and save your table design changes.
This rich text formatting shows up in table datasheets, query results, and controls on forms and reports that are bound to memo fields. Under the covers, Access applies HTML formatting code to the data.
When you are in form view, if you highlight text within a control bound to a memo field, Access displays a mini toolbar where you can apply various formatting options, as seen in the following screenshot.
Important Note:
If you create a control manually on a form or report and bind it to a Memo data type, it won't automatically display the rich text formatting, even if you set the field to accept rich text formatting in table design view. To enable the bound control to display the rich text formatting, right-click the control and go to the Property Sheet. On the All tab, select the Text Format property box, and then select Rich Text from the drop down list.
You can also use the formatting options with a table in Datasheet view. When you're in a Memo field that supports Rich Text formatting, Access enables the options in the Rich Text group on the Home tab of the Ribbon.
See more tips and tricks like this in our book: Microsoft Office Access 2007 Inside Out
Back to FAQ main page