Access Password

  • Thread starter Thread starter Abe Katz
  • Start date Start date
A

Abe Katz

Hello All!



I have controls that require to enter a password to be able to change the
data, so I use the InputBox function to enter a password first. The only
problem is that when you type the password it’s visible.

Is it possible to make the typing invisible or is there a better solution to
enter passwords.



Thank you

Abe
 
Create another form that has popup=yes and modal=yes and use the acDialog
form of the openform method to open it --- this will cause the calling
program to suspend execution until the Dialog is either closed or becomes
non-visible.

In the Dialog form, put what you would like to appear designed as a dialog
box for the user, including a control with a format specified as Password.
Provide two buttons, one to GO and one to CANCEL. Also provide a hidden
control to use as a switch. In the onclick evens for both buttons, set the
switch to some value so the calling form knows which button was pressed.
Then (still in the onclick events) set dialog form visible=false.

When the dialog form becomes non visible, control will return to the calling
program. The dialog form, although not visible to the user, is still open.
Back in the calling program, check the value of the switch in the dialog
form ... Forms![dialog form name]![switch control name] ... to see whether
GO or CANCEL was pressed. If Go was pressed, retrieve password ...
Forms![dialog form name]![password control name] ... and do what you need
with it. Then, from the calling program, close the dialog form.

Bob.
 
Back
Top