Really don't care whether or not anything was typed into the text box: I don't If the user clicks on the Cancel button, I To replace the VBA InputBox function, I need a function that'sĬapable of launching my form and sitting there, waiting until the user clicks Going to demonstrate takes advantages of that fact. Invisible), and the form is no longer a Dialog Box. Visible property for a form opened in Dialog mode to False (i.e. Now, one way around this is to recognize that you can set the Using the OpenForm method, the fact that all other code stops running makes itĭifficult for the calling routine to retrieve the values entered onto the Possible to open a form as a Dialog Box by using a WindowMode of acDialog when Would not stop to wait until the user provided the information. In the middle of a routine in my code, execution of the rest of my form's code If I were strictly to open the form that I presented in Figure 1 That you want to stop from running until the user has provided the request Why a Dialog Box is useful is because often you have code Insist that you close the form before you can move the focus to another object,īut all other code continues to function. This contrasts with Modal forms, which really only All other processing stops until the Dialogīox has been shut down. You can't use the menu bar, you can't right click, inįact you can't do anything else. Running until the Dialog Box has been dismissed.

Dialog Boxes have the ability to stop all other processing from It's important to recognize that the InputBox function producesĪ Dialog Box. This form will be used to replicate theĪppearance of the InputBox function's form Shown in Figure 1) that closely resembles what's produced by using the InputBoxįigure 1: frmInputBox_Password in Design view. However, for the purposes of this article, I created a form (frmInputBox_Password, In actual fact, you can do what I'm about to demonstrate withĪny form. In fact, I'm going to show you two different ways toĭo this, so that you can choose whichever one you prefer. Use the Password Input Mask and use that form instead of the one generated by InputBox function, I'm going to show you how to create your own form that does While it's not possible to change the behavior of the

Presented when you use the InputBox function in VBA to capture ad hoc input Unfortunately, this ability does not extend to the text box You can have the input converted to asterisks in the text box, so that no oneĬan read the password over his/her shoulder. You choose for the InputMask property, you can have the user's input look likeĪ telephone number without requiring the user to type parentheses or dashes, or How whatever the user types into the text box appears. Instance, the Text Box control has an InputMask property that lets you control That are available for use on forms, and what you can do with each control. Access provides a rich functionality in terms of controls

Ms access password storage