Knowledge Base

ACC: Entry Form Created by Table Wizard Too Large for Screen

Article ID: 178108

Article Last Modified on 1/22/2007

SYMPTOMS

The fields are in one column in the form, no matter how many fields you add.
The form may show all the fields, but the form area may be just slightly larger, vertically, than the form's window; this causes an unwanted vertical scroll bar at the right.

In the Database window, click the Forms tab and click New.
In the New Form box, select the table that you want the form to be based on.
Click Form Wizard, and then click OK.
Add the fields you want from the Available Fields list to the Selected Fields list, and then click Next.
On the second screen of the Form Wizard, select Columnar, and then click Finish.

The Form Wizard creates the form with all the specified fields displayed correctly.

On the Tables tab, click New, select Table Wizard, and then click OK.
Under the Sample Tables list, click Mailing List table.
In the Sample Fields, pick the Notes field and add it 20 times.
Click Next through the next screens, letting the wizard choose the defaults.
On the final screen with the checkered flag, click "Enter data into the table using a form the wizard creates for me."
Click Finish.

Note that the form which the Table Wizard creates is larger than the screen and all the fields are in one column.

Additional query words: Frame Spacing prb

Keywords: kbbug KB178108