graphic1

Exam 77-424: Microsoft Access 2013
2.0 Build Tables
2.2 Format a Table: Change Data Types and Formats (Rich Text)

Add a Comments Field

Another useful Field is the Long Text. Long Text Fields can hold a lot. In fact, Long Text Fields can store 2GB of data. There are two Field Properties worth considering: Text Format and Append Only. By marking the Field Append Only, Users can ADD to the data, but they cannot DELETE the previous entries.

 

7. Try it: Add a Memo Field

Field Name: Comments.

Data Type: Long Text.

 

Try This, Too: Edit the Field Properties

Go to Field Properties->General.

Text Format: Rich Text.

Append Only: Yes

 

Save and Close the Table, please.

 

Memo to Self: Selecting "Yes" for the Append option also Tracks the history. The history is available when you add this Field to a Form. You can right-click the Long Text Field in Form View to see the tracking.

Table Tools ->Design

graphic2