Unlocking a field

[TattyDon]

I've got a field on my data entry sheet that I would like to lock and not allow users to enter data in it. No problem with that, I have done that in the field behaviors box.

However, I would like the ability to unlock it occasionally using a script but can't find the command.

Any ideas?

[IdealData]

There is no script command to unlock a field.

A technique is to have a calculated copy of the field on the layout (you can't modify calculated fields), and behind it the real field.

Using a button/script on the calculated field you can then determine just about any set of rules you like in your script to deny/allow entry into the real field. Use the Go to field step to permit entry.

Make sure the tabbing sequence for the fields on the layout excludes the real field otherwise a user could simply "tab" into the field and bypass your security script.

[comment]

There is no script command to unlock a field.

I don't think I agree with that. Here are two methods:

Unlock.fp7.zip