In this exercise, you will create an AutoForm that displays information about each of the products carried by The Garden Company.
1. | On the Objects bar, click Forms.
|
2. | On the database window’s toolbar, click the New button to display this New Form dialog box, which lists all the ways you can create a form.

|
3. | Click AutoForm: Columnar in the list of choices, click the down arrow to the right of the box at the bottom of the dialog box, click Categories, and then click OK.
The dialog box closes, and after a moment a new Categories form is displayed in Form view.
|
4. | Click the Save button, accept the default name of Categories in the Save As dialog box, and click OK to view the form.

Tip
When AutoForm creates a form, Access applies the background style you selected the last time you used the Form Wizard (or the default style, if you haven’t used the wizard). If your form doesn’t look like this one, switch to Design view, and on the Format menu, click AutoFormat. You can then select The Garden Company style from the list displayed.
|
5. | This form looks pretty good as it is, but switch to Design view so that you can make a few minor changes.
|
6. | Delete the word Category from the Category Name label.
|
7. | The CategoryID value is provided by Access and should never be changed, so you need to disable that text box control. Click the control and if necessary, press  to display the control’s Properties dialog box.
|
8. | On the Data tab, change Enabled to No, and close the dialog box.
Disabling the CategoryID text box changes it, and the label text, to gray.
|
9. | Switch to Form view, and scroll through a few categories. Try to edit entries in the Category ID field to confirm that you can’t.
|
10. | You don’t need scroll bars or a record selector in this form, so return to Design view, and display the form’s Properties dialog box by clicking the Form selector and pressing  . On the Format tab, change Scroll Bars to Neither and Record Selectors to No, and then close the dialog box.
|
11. | Save and close the Categories form.
|