1. Start Microsoft Access, and on the File menu, click New Database.
2. In the New dialog box, click the Databases tab, click the Expenses database, and then click OK.
3. In the File New Database dialog box, click Create to create a new database with the default file name.
4. On the first screen of the Database wizard, click Next.
5. On the second screen, note that in the Fields in the Table list box, the Email Name field is not selected.
6. Click Finish to accept the default database settings. When the new database is created, press F11 to bring up the Database window.
7. Open the Employees table in Design view. Add a new field with the following properties to the table:

      Table: Addresses
      --------------------------
      Field Name: Email Name
         Data Type: Text
         Indexed: No
   						

   NOTE: If you want to add the additional field between a particular row, select the row, and then on the Insert menu, click Rows.
8. After adding the Email Name field, close the table.
9. Open the Expense Report by Employee form in Design view. If the field list is not displayed, on the View menu, click Field List. Drag the Email Name field from the field list to the location where you want it on the form.
10. Open the form in Form view. Note that the optional field now appears on the form.

Back to the top

Steps to Reproduce Behavior

1. Repeat steps 1 through 5 in the "Resolution" section earlier in this article.
2. Click Finish to accept the default database settings. When the new database is created, press the F11 key to bring up the Database window.
3. Open the form in Design view.
   
   Note that none of the optional fields appear on the form.

Back to the top