InputBox Function in a Query - Hidden Response

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am writing a simple query which ask for data which I do not want to be
viewed on screen. The criteria is: [Please Enter Your Password:] and this
appears ok and all the reactions are as expected.

What I want to know is how to I make the answer on screen be shielded by a
series of ***** in order to keep it hidden from prying eyes. I do not need a
complex security system or code as it would be too extreme for the task in
hand.

Is this possible? Is there a simple command or property that can allow this?
Thanks for any advice.

Rich
 
Hi,

I am writing a simple query which ask for data which I do not want to be
viewed on screen. The criteria is: [Please Enter Your Password:] and this
appears ok and all the reactions are as expected.

What I want to know is how to I make the answer on screen be shielded by a
series of ***** in order to keep it hidden from prying eyes. I do not need a
complex security system or code as it would be too extreme for the task in
hand.

Is this possible? Is there a simple command or property that can allow this?
Thanks for any advice.

Rich
Click to expand...

Not possible in the query itself.
Create a form. Add an unbound text control.
Set the Input Mask to Password.
Add a command button.
Code the command button:
DoCmd.OpenQuery "QueryName"
DoCmd.Close acForm, Me.Name

As criteria in the query, instead of your
[Please Enter Your Password:], write:
forms!FormName!ControlName

Run the query from this form.
However if the query is really the record source for a report, then,
while similar, the method is a bit different.
Post back if you still need help.
 
Back
Top