To create a masked Password input field, open your form in ArcPad Studio, add an input text control to your form. Then under the control properties, check on the "Password" check box.
Now, each character you enter in that text box will be displayed as asterisk (*).
To get the value of the input password, just use:
pControls("txtPassword").Value
where, "txtPassword" is the name of that control.