Hiding Data

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hello I have implimented my own security with a little bit
of Access's own as well. I would like to be able to hide a
certain record whn certain users log in... so for example

If there is a password field when user1 logs in they can
see the password but if user2 logs in they get all ***
hiding the password could this be done?

Many Thanks

James
 
James

I don't know if this will help, but I believe you can set an InputMask
property to treat a field as a "Password" (using the "****"). If you first
check the UserName control, you could modify the InputMask on the Password
control.

Good luck

Jeff Boyce
<Access MVP>
 
Thanks for that Yes you can have the input mask as a
password field... This I was looking at but it would
change all the values... where as I just want it to do
one... Then in your response there was something I didnt
understand and it was this:

"If you first check the UserName control, you could modify
the InputMask on the Password control"

Does the above mean that if I say something along the
lines of if Usr = User2 then inputmask of record blah set
to password...

Or am I on the wrong lines? Because if the statement above
is corrent I have no idea at all as to how I can write the
code for it???

Many Thanks

James
 
Back
Top