Input of "Inputbox"

Hi all, i have an input box that i need the user to put in a password
and just wondered if it is possible to just show a * as he types in the
letters as per the normal password inputbox ?

any help is much appreciated.

best regards,

re: Input of "Inputbox"

Les wrote in message
<1142239079.350697.22200@j33g2000cwa.googlegroups. com> :[color=blue]
> Hi all, i have an input box that i need the user to put in a password
> and just wondered if it is possible to just show a * as he types in the
> letters as per the normal password inputbox ?
>
> any help is much appreciated.
>
> best regards,[/color]

I think I've seen some creative coding involving APIs and whatnots, but
I think I'd be blunt enough to state that the inputbox doesn't have
such features, and one will probably be better off creating a small
form
with a text control using the Password inputmask.

--
Roy-Vidar

re: Input of "Inputbox"

Thanks Roy

re: Input of "Inputbox"

On 13 Mar 2006 00:37:59 -0800, Les wrote:
[color=blue]
> Hi all, i have an input box that i need the user to put in a password
> and just wondered if it is possible to just show a * as he types in the
> letters as per the normal password inputbox ?
>
> any help is much appreciated.
>
> best regards,[/color]

Create an unbound form with an unbound control.
Set the control's input mask property to "Password".
Add a command button to this form.
Code it's click event:
Me.Visible = False
Name this form "PassForm"

You would then call this form (instead of the InputBox).

DoCmd.OpenForm "PassForm", , , , , acDialog
If Forms!FormName!ControlName = "The Password" then
' Correct password do whatever is wanted here
Else
' Wrong Password do something else.
End if
DoCmd.Close acForm, "PassForm"

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail