Solved Password character for InputBox Function (1 Viewer)

Sarah.M

Member
Local time
Today, 21:11
Joined
Oct 28, 2021
Messages
335
Hi, Plz note, My VBA is blocked by IT for security reason (Cybersecurity).
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
------------------------------------------------
Inputbox is very useful, but the numbers are visible, is it possible to let input box for password to show the numbers as *****
or is there any alternative to InputBox function that can be used with Password?
plz help 🙏

1649761665517.png

1649761742951.png
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 02:11
Joined
May 7, 2009
Messages
19,169
create a form similar to your input box.
add formatting to the Textbox (password).
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 02:11
Joined
May 7, 2009
Messages
19,169
like i said you can create the form.
you can add a macro that will open this form and
supply the Caption, the Prompt and the Default value (see mcrInputBox).

run the macro.

the Return is either (Null or "", if Cancel is pressed) or the value typed.
this value is saved in Tempvars!InputValue.

If Len(Tempvars!InputValue & "") <> 0 Then
Debug.Print TempVars!InputValue
End If
 

Attachments

  • dbPassword.accdb
    380 KB · Views: 205

Users who are viewing this thread

Top Bottom