Below is a code i am using, what i want is the password to be in caps. and the InputBox to auto use caps as the user type in the password? also problem with the formating is it shows the password as it is type is there a way to mask this using a InputBox so as i type the password is would show *****?
Private Sub START_TIME_GotFocus()
strPasswd = InputBox("Please Enter Admin Password", "Start Time is Restricted")
'Check to see if there is any entry made to input box, or if
'cancel button is pressed. If no entry made then exit sub.
If strPasswd = "" Or strPasswd = Empty Then
MsgBox "No Password Provided", vbInformation, "Password Required"
'If correct password is entered unlock Start_Time
'If incorrect password entered give message and exit sub
If strPasswd = "JAX" Then
Me.START_TIME.Locked = False
MsgBox "Sorry, you do not have access to the start time", vbOKOnly, "Password Incorrect!"