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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.