Show password chk on a contious form to show that password as selected?

[d9pierce1]

ShowPassword.zip

Hi all and good morning,

I have a problem that is just driving me crazy.
I have attached db and is just a form, qry, and a few tables, really simple... Sample Data is bogus....
db opens to form in question.

I have a form that has shows me the business (Institution) and website
Along with a continous sub form that shows
password, username, and login and last changed. Its where i store my online stuff..

I also has a checkbox to show password with code below.
The problem is if I tic the showpassword chkbox, it shows (In this case) all the passwords in that form record.
So if I have two users, it shows both passwords instead of just the one i have the record selector on.

 
'Just one of many samples i have tried.....current one in 
Private Sub ShowPassword_Click()
  If Me.ShowPassword = True & "OnLineAccessUserID=" & Me.OnlineAccessUserID Then
    Me.Password.InputMask = ""
  Else
    Me.Password.InputMask = "Password"
  End If
  Call Form_Current
End Sub

The goal is to check the chkbox and show the password for the current record that is selected.

I have tried many different methods to overcome this and cannot for any reason figure out how to just show the password to the record selected?
Just driving me absolutely nuts. Not a major issue with this as my wife and I are the only users but would like to know how to accomplish this task



I am sure there is a way, i just dont know the path to take.

Thanks
Dave

[Micron]

I don't think you can alter that property in one instance of a textbox on a continuous form, and conditional formatting doesn't have the ability to modify that property either. You would have to change your form to single view, which shouldn't be a huge problem, no? Actually, anything that results in the form only having one instance of the textbox would suffice, and that could include moving the field to the main form.

[Gicu]

What you see is the expected behaviour for continuous forms, changing the formatting of a control will apply to all records. Please review the updated file where I give you two options. One uses conditional formatting and is closer to your desired approach, the other simply calls a msgbox to display the password for the current record.
Cheers,

[d9pierce1]

Thanks everyone,
I will look these over and see what i come up with.
Thanks again,
Dave

[isladogs]

NEVER use any code that displays the password...even if you fix this so its for the current user.
Once that is visible on the screen it can be viewed by whoever is nearby.
It also means that the DB admin can view everyone's password which is a HUGE red flag.
That could risk you being liable for any issues that arise as a result.

If you really must store passwords within Access, they should be strongly encrypted using e,g. AES or RC4 encryption.
Better still, use Active Directory passwords instead of using passwords in Access.

[Micron]

Agree, and for one second on my soapbox say again that IMO for most situations, passwords in Access are a waste of time. In the posted solution, double click the field, right click, select copy and paste the password into notepad. Zero security or privacy there, especially if anyone can do this on that form. Unless you absolutely need Access passwords, check Windows login against a table of users. AFAIK, not even a network admin can see your Windows password. If that's incorrect, it doesn't matter as it's way above those who are casual db admins or users.

[Gicu]

I agree with both of you but I according to the OP this is nothing other than a small personal db keeping track of websites and their respective logon ins.

I have a form that has shows me the business (Institution) and website

Just driving me absolutely nuts. Not a major issue with this as my wife and I are the only users but would like to know how to accomplish this task

Cheers,