Microsoft® Office Access™ 2007 Plain & Simple

Creating an Append-Only Memo Field

Most database table fields contain dry, factual data such as prices, quantities, and descriptions. You can extend the facts in your tables by creating memo fields, which can contain up to 64,000 characters. Memo fields are ideal for storing comments about database records, but you might not want to allow users to delete existing comments. To allow users to add but not delete comments to a memo field, you can make the memo field an append-only field.

Create an Append-Only Field

1. Open a table in Design view.

2. Click the ...