Microsoft KB Archive/179713

= ACC97: Optional Fields Not Added to Database Made by Database Wizard =

Article ID: 179713

Article Last Modified on 1/22/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q179713



Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
When you use the Database wizard to create a database, optional fields are not added to the database. You must manually select optional fields before the wizard includes them.



RESOLUTION
If you decide that you want to add optional fields to the forms that are created with the wizard, you must add the fields to the existing table and then drag the fields from the field list to display them on your existing form. The following steps demonstrate how to add the Children Names field from the Address template to the database created by the wizard.

 Start Microsoft Access, and on the File menu, click New Database. In the New dialog box, click the Databases tab, click the Address Book database, and then click OK. In the File New Database dialog box, click Create to create a new database with the default file name. On the first screen of the Database wizard, click Next. On the second screen, note that in the "Fields in the Table" list box, the Children Names field is not selected. Click Finish to accept the default database settings. When the new database is created, press F11 to bring up the Database window.</li>  Open the Addresses table in Design view. Add a new field with the following properties to the table:

<pre class="fixed_text">       Table: Addresses --       Field Name: Children Names 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. </li> After adding the Children Names field, close the table.</li> Open the Addresses form in Design view. On the View menu, click Field list. Drag the Children Names field from the Field list to the location you want on the form.</li> Open the form in Form view. Note that the optional field now appears on the form.</li></ol>

<div class="status_section">

STATUS
This behavior is by design.

<div class="moreinformation_section">

Steps to Reproduce Behavior

 * 1) Repeat steps 1 through 5 in the "Resolution" section.
 * 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 Addresses form in Design view.

Note that none of the optional fields appear on the form.

<div class="references_section">