Password Usage

[HB]

Please Help

In my application I need the user to type their password everytime they
perform a certain task. I am using the inputbox function for this but anyone
looking over their shoulder can read their password as they type. Is their a
way I can cause a * to show instead of the actual letters?

Thanks in advance.

Brian

[Sandra Daigle]

Re: Password Usage

Instead of using the Inputbox function you should probably create a custom
form and for the password field set the InputMask property to 'Password'.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.


HB wrote:[color=blue]
> Please Help
>
> In my application I need the user to type their password everytime
> they perform a certain task. I am using the inputbox function for
> this but anyone looking over their shoulder can read their password
> as they type. Is their a way I can cause a * to show instead of the
> actual letters?
>
> Thanks in advance.
>
> Brian[/color]

[Betsy]

Re: Password Usage


Hi-

In design view of the form, open the properties window for the control where
the user enters their password. Go to the data tab and use the Input mask
wizard to assign a password mask for this control.

HTH-- Betsy W.


"HB" <frmnook@telus. net> wrote in message
news:8ML5b.7224 1$ho5.1314591@n ews2.telusplane t.net...[color=blue]
> Please Help
>
> In my application I need the user to type their password everytime they
> perform a certain task. I am using the inputbox function for this but[/color]
anyone[color=blue]
> looking over their shoulder can read their password as they type. Is their[/color]
a[color=blue]
> way I can cause a * to show instead of the actual letters?
>
> Thanks in advance.
>
> Brian
>
>[/color]

[HB]

Re: Password Usage

Thanks Sandra & Betsy

I previously tried that bu since I was calling the form from a form module
in VB code, It would open the form and continue the VB code without waiting
for a typed password. Is there a way I can use docmd openform ... then wait
for the response, then continue the calling code where it left off?

Thanks again

Brian




"Sandra Daigle" <SMDaigle@MVPS. org> wrote in message
news:OqqdWexcDH A.2416@TK2MSFTN GP09.phx.gbl...[color=blue]
> Instead of using the Inputbox function you should probably create a custom
> form and for the password field set the InputMask property to 'Password'.
>
> --
> Sandra Daigle
> [Microsoft Access MVP]
> For the benefit of others please post all replies to this newsgroup.
>
>
> HB wrote:[color=green]
> > Please Help
> >
> > In my application I need the user to type their password everytime
> > they perform a certain task. I am using the inputbox function for
> > this but anyone looking over their shoulder can read their password
> > as they type. Is their a way I can cause a * to show instead of the
> > actual letters?
> >
> > Thanks in advance.
> >
> > Brian[/color]
>[/color]

[Sandra Daigle]

Re: Password Usage

Yes, use the acDialog option of the Windowmode parameter of the openform
command. This will suspend the code until the opened form is either
hidden or closed.

docmd.OpenForm "frmMyForm",,,, ,acDialog

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.


HB wrote:[color=blue]
> Thanks Sandra & Betsy
>
> I previously tried that bu since I was calling the form from a form
> module in VB code, It would open the form and continue the VB code
> without waiting for a typed password. Is there a way I can use docmd
> openform ... then wait for the response, then continue the calling
> code where it left off?
>
> Thanks again
>
> Brian
>
>
>
>
> "Sandra Daigle" <SMDaigle@MVPS. org> wrote in message
> news:OqqdWexcDH A.2416@TK2MSFTN GP09.phx.gbl...[color=green]
>> Instead of using the Inputbox function you should probably create a
>> custom form and for the password field set the InputMask property to
>> 'Password'.
>>
>> --
>> Sandra Daigle
>> [Microsoft Access MVP]
>> For the benefit of others please post all replies to this newsgroup.
>>
>>
>> HB wrote:[color=darkred]
>>> Please Help
>>>
>>> In my application I need the user to type their password everytime
>>> they perform a certain task. I am using the inputbox function for
>>> this but anyone looking over their shoulder can read their password
>>> as they type. Is their a way I can cause a * to show instead of the
>>> actual letters?
>>>
>>> Thanks in advance.
>>>
>>> Brian[/color][/color][/color]

[HB]

Re: Password Usage

AWESOME - Thanks



"Sandra Daigle" <SMDaigle@MVPS. org> wrote in message
news:ekAy4Q#cDH A.904@TK2MSFTNG P11.phx.gbl...[color=blue]
> Yes, use the acDialog option of the Windowmode parameter of the openform
> command. This will suspend the code until the opened form is either
> hidden or closed.
>
> docmd.OpenForm "frmMyForm",,,, ,acDialog
>
> --
> Sandra Daigle
> [Microsoft Access MVP]
> For the benefit of others please post all replies to this newsgroup.
>
>
> HB wrote:[color=green]
> > Thanks Sandra & Betsy
> >
> > I previously tried that bu since I was calling the form from a form
> > module in VB code, It would open the form and continue the VB code
> > without waiting for a typed password. Is there a way I can use docmd
> > openform ... then wait for the response, then continue the calling
> > code where it left off?
> >
> > Thanks again
> >
> > Brian
> >
> >
> >
> >
> > "Sandra Daigle" <SMDaigle@MVPS. org> wrote in message
> > news:OqqdWexcDH A.2416@TK2MSFTN GP09.phx.gbl...[color=darkred]
> >> Instead of using the Inputbox function you should probably create a
> >> custom form and for the password field set the InputMask property to
> >> 'Password'.
> >>
> >> --
> >> Sandra Daigle
> >> [Microsoft Access MVP]
> >> For the benefit of others please post all replies to this newsgroup.
> >>
> >>
> >> HB wrote:
> >>> Please Help
> >>>
> >>> In my application I need the user to type their password everytime
> >>> they perform a certain task. I am using the inputbox function for
> >>> this but anyone looking over their shoulder can read their password
> >>> as they type. Is their a way I can cause a * to show instead of the
> >>> actual letters?
> >>>
> >>> Thanks in advance.
> >>>
> >>> Brian[/color][/color][/color]