Password protect a field

[spn200286]

is it possible to make a certain field in a form password protected to edit (but avaliable for everyone to view)

if that makes sence, just say if more detail is needed

 

[KenHigg]

The only way would be to build your own little routine that unlocked it.

 

[spn200286]

The only way would be to build your own little routine that unlocked it.

and here i was hoping there was a nice bit of VBA that would just ask for a password, umm, any sugestions about how to go about that?

 

[odin1701]

There is some VBA - I used this here when I needed to do it:

http://www.tek-tips.com/faqs.cfm?fid=4617

That will bring up an input box to use to enter a password, and it will mask the password.

You can set your text field to locked, and on double click have it bring up the password input and have a password in the VBA code to compare that to. If it matches, unlock it. Be sure to handle making sure that it is locked again depending on what you want.