Build an Intuitive Date Control Using an Office UserForm

摘要

UserForms let you work with the wealth of ActiveX controls easily and create utilities that can be used in any Office component. See how to create a sophisticated calendar control to use in Access. UserForms are an important Office component for controlling user input and developers use them primarily in the "other" Office components that lack Access' powerful forms, such as Excel. Implementing UserForms in Access is tricky, but the result is worth the effort. UserForms are compatible with other Office applications and the resulting form is easier to automate. In this article, we'll walk you through the process of inserting a UserForm that displays an ActiveX date control in an Access application. First, though, you need to know when UserForms are superior to Access forms.