InputBox

[Guest]

Dear gurus,

I use the following code to open a form. Is it possible to hide with
asterisks (password input) what i type in the inputBox?

Thank you in advance

Function OpenFormWithInput()
Dim Msg As String
Dim Title As String
Dim Defvalue As String
Dim Answer As String

Msg = "Enter Password"
Title = "Password verification"
Defvalue = ""
Answer = InputBox(Msg, Title, Defvalue)
If Answer = "123" Then
DoCmd.RunMacro "M_OpenF_DataEntry"
Else
MsgBox "This is an incorrect Password... Try again!"
End If
End Function

 

[TC]

No. The InputBox() function will display whatever is entered. Instead,
consider using a popup modal form with a textbox whose Format property
is set to "Password" IIRC.

HTH,
TC (MVP Access)
http://tc2.atspace.com

 

[Guest]

Thank you TC for your prompt reply. I will use thena popup modal form

Ο χÏήστης "TC" έγγÏαψε:

 

[TS Lim]

Kindly advsie how to set the textbox format to "Password" IIRC.

Regards,
TS Lim

 

[Douglas J. Steele]

It's not the Format you set to Password, it's the InputMask.

 

[TS Lim]

I got it. Thanks.

It's not the Format you set to Password, it's the InputMask.