vba courses london - Vba password checking and input mask

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Vba password checking and input mask

Susan has attended:
Access VBA course

by - delegate Susan [3 posts] (2007 Apr 27 Fri, 12:11) Reply

I have a non visible text box on my form called formpassword. I want to display an inputbox and for the characters the person types to appear as asterisks. The following code works but the password is not displayed as asterisks. Please can you tell me how I can do this?

Me.formpassword.InputMask = "password"
Me.formpassword = InputBox("Please enter password")

If formpassword <> "abc" Then
MsgBox "Incorrect password"
DoCmd.Close
Exit Sub
End If

Thanks

Sue

RE: vba password checking and input mask

by - trainer Garry gold contributer [188 posts] (2007 May 16 Wed, 11:09) Reply

VB.net provides a template for a login form and all your going to have to do is a little bit of coding to make it all happen.

An article on this is as follows.

http://www.vb-helper.com/howto_net_login_form.html

· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Company Roles in Visual Basic Training

Vba tip:

Stop Display Alerts In Excel

When creating or deleting a Worksheet in Excel you don't want Excel to inform you "A file already exists....." Or "Do you want to save this file...".

To stop these alerts happening use the following line of code:

Application.DisplayAlerts = False

After the Create or Delete routine use:

Application.DisplayAlerts = True

View all VBA hints and tips