Input of "Inputbox"

[Les]

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,

[RoyVidar]

Re: Input of "Inputbox& quot;

Les wrote in message
<1142239079.350 697.22200@j33g2 000cwa.googlegr oups.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

[Les]

Re: Input of &quot;Inputbox& quot;

Thanks Roy

[fredg]

Re: Input of &quot;Inputbox& quot;

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