How can I hide my text in asking input box?

  • Thread starter Thread starter hanski
  • Start date Start date
H

hanski

Hi.

I made one input box, where it asks the user to input his secret code.
Is it possible to convert his code so that you can see only ****-marks
when he is inputting the code?

Hannu
 
I made one input box, where it asks the user to input his secret code.
Is it possible to convert his code so that you can see only ****-marks
when he is inputting the code?
Click to expand...

If the input box is a form, set the format of the password text box to
Password.

Tom Lake
 
Thank you, but how can I do it in VBA?

This is simle code:

Option Compare Database

Dim k As String

k = InputBox("Give me your secret code")


Where comes to inputmask?

hannu



BruceM kirjoitti:
 
There are no input mask or formatting capabilites for an Input Box. To
accomplish your goal, you will need to create a form to accept the entry and
use the PassWord Input Mask.
 
I responded too quickly, without considering that you were asking about an
input box rather than a pop-up form. As Klatuu pointed out, an Input Box
does not accept input masks. You will need to use a pop-up form instead,
although I have to wonder from whom this information is being concealed. If
the user types a password into an input box, it seems to me that the only
realistic potential problem is the person looking over the user's shoulder.
 
Back
Top