To get the password masked, just insert a textbox in your form and set its
"input mask" property to "password" (look under the "All" tab in the
properties box - the input mask is the fifth line down. You will need to
press the "..." to bring up the password option).
To force the values to lower case just use the LCase function. Eg if your
textbox is called txtpassword, just use something like this:
Dim strPassword As String
strPassword = LCase(Me.txtpassword.value)
Then you can do whatever you want with the contents of the strPassword
variable.
Hope this helps.
Regards
Bob