Share this Page URL

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

Designing Basic Forms 265 12. 13. The first column, EmployeeID, will not be visible because its width is set to 0, even though the employee ID will be stored in the AssignedTo field, which is the control source for the combo box. Switch the Tasks form to Form view, and you can now see employee last names in the combo box we created. Save the changes to the Tasks form, and then close the form. Just the Steps Convert a text box to a combo box 1. 2. 3. 4. 5. With the form open in Design view, right-click the text box, and then click Properties. Click in the Record Source property box (on the Data tab), and then click the Build button. In the Query Builder window, add the table or tables with the values you want to display in the combo box. Add the field or fields to the query design grid, and then close and save the changes to the Record Source property. On the Data tab of the Properties dialog box, set the Limit To List property to Yes (if you want to limit the values that can be selected in the combo box to the values in the list). Also set the Bound Column property to the field you want to bind to the control. If you've added more than one field to the Query Builder, use the Format tab of the Properties dialog box to set the Column Count property to show the number of fields, and then enter values in the Column Width property to show or hide the values you want to display. 6. Quick Check Q. Does Access include commands that I can use to quickly align controls or change the spacing or size of controls? A. Yes, use commands on the Format menu--Align, Size, Horizontal Spacing, and Vertical Spacing. Q. How is the default tab order for a form determined? A. The tab order is determined by the order in which you add controls to a form. If you're using the Form Wizard, the tab order follows the order of the fields in the Selected Field list. You can change the tab order for a form in the Tab Order dialog box.