Create a field for text or memos

Create a field for text or memos

  1. Open a table in Design view.

  2. To insert the field within the table, click in the row below where you want to add the field, and then click Insert Rows on the toolbar.

    To add the field to the end of the table, click in the first blank row.

  3. In the Field Name column, type the name for the field, following Microsoft Access object-naming rules.

  4. In the Data Type column, click the arrow and select either Text or Memo. For information on which data type to use for different circumstances, click .

  5. Set the other field properties, if desired.

    How?

Note   The default field size for Text fields is 50 characters. You can change this for a particular field by setting the FieldSize property. You can change the default field size itself by clicking the Options command on the Tools menu, and then by clicking the Tables/Queries tab.