value in a text box

[azhar2006]

Hi, All


How the user can not change the value in a text box, but the existence password
Text box on the form
No user can (Delete / Edit) what is in the inside of the text
But show him a message asking him for the password until you change

[rpeare]

I do not understand this question.

[azhar2006]

Lock the textbox. Put a button next to it, which needs to be clicked in order to "unlock" the textbox.

[rpeare]

So you want to do this:

1. Start with the data on your form being locked
2. If someone wants to change data have a button to unlock the data
3. If someone clicks that button they must enter a password
4. If the password is valid the record or field unlocks
5. When the record is saved the controls lock again

is this correct?

I think the only way this is going to work the way you want is if you are doing data entry on an UNBOUND form, otherwise you will be unlocking the controls on ALL records which you probably do not want.

[azhar2006]

Yes
this correct?
But not every form fields but only one field

[rpeare]

if you are using a BOUND form this will not function the way you want it to, are you using a BOUND form. A BOUND form means that your form is tied directly to a query or a table and the data you change/add/edit is immediately reflected in the data in the source table.

[azhar2006]

Thank you very much rpeare
I want the box to be locked when the user goes to a new record, you will need to lock the text box in the form. And only unlock it with the Button or maybe on double clicking the text box ?
But how ?
What is the code (VBA) or Function
Is it possible for example

[rpeare]

you are not answering the central issue here.

Are you using a bound form?

if you are, what you are trying to do will not work

when you 'unlock' a specific field it will unlock it on ALL records which is not what you want.

the code to lock/unlock a control is very simple it's just

fieldname.locked = true
or
fieldname.locked = false

Final warning though, this will not function the way you want on a bound form especially if it's a continuous form.

[azhar2006]

Yes rpeare
I Use a bound form
Only when the focus
Or position the mouse pointer inside