Share this Page URL

Chapter 7. Designing Basic Forms > Adding a Control to a Form - Pg. 261

Designing Basic Forms 261 Checking errors as you design forms and reports You can set up Access so that it detects common errors you might make when you design a form or a report. (The ability to detect errors is a feature new to Microsoft Office Access 2003.) To use error checking, open the Options dialog box from the Tools menu. On the Error Checking tab, select Enable Error Checking, and then select the types of errors you want Access to check for. Access can check for errors such as whether a label control on a form has no control associated with it. When Access detects an error, it displays a small triangle in the upper left corner of a control. When you click on the triangle, Access displays a smart tag. When you point at the smart tag, Access displays a menu of options you can use to correct the error or ignore it. Tips About the Toolbox Here are several tips for working with the toolbox: · Each tool in the toolbox is identified by a ToolTip that you can display by positioning the mouse pointer over the tool. · To make room in the Form Design window, you can drag the toolbox to a border of the window and dock it. You can hide or display the toolbox by clicking Toolbox on the View menu. · You can use the toolbox and the field list together to associate a particular type of control with a field when you add it to a form. In the toolbox, click the type of control you want to add to the form. Then drag the field you want to associate with the control from the field list to the form. · If you need to add more than one control of the same type to a form, double-click the tool for that control in the toolbox. Click in the form where you want to place the first control. Click again where you want to place the next instance of the control. Click the Select Control tool in the tool-box when you've finished adding the controls you need. Add a combo box to a form 1. On the Tasks form, click the AssignedBy text box, and then press Delete. We'll replace this text box in the next step with a combo box. We'll set the Control Source property of the combo box to the AssignedBy field. The combo box will display a list of em- ployees, and we can then select the one who initiated the task. The Combo Box Wizard will do most of the work, as you'll see in the following steps. In the toolbox, click the combo box tool, and then click above the AssignedTo text box on the form. You'll see the first screen of the Combo Box Wizard: 2.