SueHunting
Programmer
A text box etc. can be given the mask property of 'password' so that asterisks appear when data is typed in. Is there a way of assigning this property to the string typed into an InputBox?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can properties be sssigned to the string returned from an InputBox
- Thread starter SueHunting
- Start date
- Status
suehunting,
The best way to deal with this is to use a form instead of InputBox, and when you open the form open it in mode acDialog, this will cause code to stop and wait until the form is closed, (when they enter data an hit your OK button, or Cancel button). Then you can have any kind of control(s) you want on the form. The values can be returned in public variable or array, if you have multiple controls, just make sure you init the variable just prior to the OpenForm call, and check it just after.
--jsteph
The best way to deal with this is to use a form instead of InputBox, and when you open the form open it in mode acDialog, this will cause code to stop and wait until the form is closed, (when they enter data an hit your OK button, or Cancel button). Then you can have any kind of control(s) you want on the form. The values can be returned in public variable or array, if you have multiple controls, just make sure you init the variable just prior to the OpenForm call, and check it just after.
--jsteph
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question