As sometimes happens when you develop an application, you (or the user) might change your mind about what kind of control you want to use to represent a particular field. Access has a way of dealing with this situation. You can morph controls either through the user interface (UI) at form design time with Access menus, or you can morph them in code using VBA at runtime.

Morphing Controls at Design Time

Changing controls from one type to another at design time, also called morphing, is simple. For example, open the ComboBoxExample1 form in Design view. Now highlight the cboEmployeeToQuery combo box and then choose Change To from the Format menu.

Notice that because it's a combo box that's being changed, the only choices ...

Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.