When printing this page, you must include the entire legal notice.
Memo field property reference Understand Memo fields If you are new to Access, remember that the data in a database resides in one or more tables. In turn, each table consists of a set of fields columnsand each field is set to accept one specific type of data.
Memo field specifications Memo fields in Office Access can store up to 1 gigabyte of characters, or 2 gigabytes of storage 2 bytes per characterof which you can display 65, characters in a control on a form or report.
In addition, you can now apply rich-text formatting to the data in a Memo field. For example, you can set colors, change fonts, and make data bold or italic.
For more information about how you can format rich-text data in a Memo field, see the article Format data in tables, forms, and reports. Ways to create a Memo field Office Access provides several ways to add a Memo field to a new or existing table: For more information about the properties that you can set for a Memo field, see the section Memo field property reference.
You can use either technique when you create new tables and when you modify existing tables. Top of Page Add a Memo field in Datasheet view The steps in this section explain how to add a Memo field to a new or existing table in Datasheet view.
If you're new to Access, a datasheet is a grid similar to an Excel worksheet. In the Open dialog box, select and open the database. In the Navigation Pane, double-click the table that you want to change.
Access opens the table in Datasheet view. If necessary, scroll horizontally to the first blank field. By default, Access displays Add New Field in the header row of all new fields, like so: Double-click the header row and enter a name for the new field.
Typically, you apply names such as "Comments" or "Notes" to a Memo field. Select the first blank row under the header and enter a block of text longer than characters.
Access applies the Memo data type to the field because the field contains more than characters. Alternatively, you can paste more than characters of text data into the first row.
On the Create tab, in the Tables group, click Table. Access opens the new table in Datasheet view. Double-click the header row for the first table field the one labeled Add New Fieldand type a name for the field. Typically, names such as "Comments" or "Notes" are applied to a Memo field.
Select the first blank row under the header and type a block of text longer than characters. Alternatively, you can paste more than characters of text data into the field.
Top of Page Add a Memo field in Design view You use Design view when you need to add a Memo field to a new or existing table, and then set the field to support rich-text formatting. The steps in this section explain how to add a Memo field to existing and new tables, and how to set the Memo field for rich-text editing.
In the Navigation Pane, right-click the table that you want to change and click Design View. In the Field Name column, select the first blank row and enter a name for the field.
Select the adjacent cell in the Data Type column, and then select Memo from the list. Right-click the document tab for the new table and click Design View on the shortcut menu. Save your changes and if you want to enable rich-text editing for the field, continue to the next steps. If you bind a text box to your memo field, you must also set the Text Format property for the text box to Rich Text.
However, when you delete a Memo field that contains data, you lose that data permanently.Automatic works cited and bibliography formatting for MLA, APA and Chicago/Turabian citation styles. Now supports 7th edition of MLA. Put what you want the reader to get out of the memo at the top and then continue to go into more detail in the body of the memo.
This is known as an inverted pyramid style of writing. This style of writing is important because readers often only take time to skim memos. Since field reports do not have a standard format, it is worthwhile to determine from your professor what the preferred organization should be before you begin to write.
Guidelines for Effective Informational Memos Writing clear, informative memos is a critical to your career whether you are a policy maker, engineer, architect, consultant, or activist. This step is optional, as the email header at the top of the message already follows the memo format.
Tip Create a shortcut to the template file so that you can easily open it the next time you want to send a memo. When you use the block form to write a business letter, all the information is typed flush left, with one-inch margins all around.
First provide your own address, then skip a line and provide the date, then skip one more line and provide the inside address of the party to whom the letter is addressed.