Quickly change an Access control's type (97/2000/2002)

You or your end users will likely come across situations where you want to change a form or report control's control type. For instance a field that's set up as a combo box lookup at the table design level will appear as a combo box when it's added to a form. This is often convenient, but if you're displaying the data in the field as read-only, it makes more sense to display the information in a regular text box than a dropdown control. 

Fortunately, it's easy to change the control types for many form and report controls. Just right-click on the control you want to change, select Change To from the shortcut menu and then choose the new control type you want to use. The new control type has to be functionally similar to the original control type, so only the valid control type selections will be enabled in the shortcut menu.

<<<Back Home Next>>>