Control Morphing
When you first build a form, you might not always choose the best type of control to display each field on the form, or you might make what you think is the best choice for the control, only to find out later that it wasn't exactly what your user had in mind. In Access, it's easy to morph , or convert, the type of control into another type. For example, you can morph a list box into a combo box, a text box into a combo box, or a combo box to a text box.
Morphing a Text Box to a Combo Box
One of the most common types of conversions is from a text box to a combo box. To morph a text box to a combo box, right-click on the text box. Choose Change To, and then select Combo Box. The types of controls available depend on the type of control you're morphing. For example, a text box can be converted to a label, list box, or combo box (see Figure 5.29).
Figure 5.29. Morphing a text box.

After morphing a text box to a combo box, you modify the appropriate Control properties. The Row Source, Bound Column, Column Count, and Column Widths properties need to be filled in. For the row source, you must select the appropriate table or query. If you select a table and then click the ellipsis, you are prompted to create a query based on the table. After selecting Yes, you can build a query containing only the fields you want to include in the combo box. You're then ready to select the bound column, which is used to store data in the underlying table. For example, the user might select the name of a project that a payment is being applied to, but the ProjectID will be stored in the Payments table. Set the column count to the number of columns selected in the underlying query; the column widths can be set so that the key column is hidden.
Morphing a Combo Box to a List Box
Morphing a combo box to a list box is a much simpler process than morphing a text box to a combo box or a list box because combo boxes and list boxes share so many properties. To morph a combo box to a list box, simply right-click on the combo box and choose Change To, List Box.