Locking fields

[yalebulldog]

Is there a way to lock a field after the data has been enter? Thanks for the help

[Steven H. Blackwell]

quote:

---

Originally posted by yalebulldog:

Is there a way to lock a field after the data has been enter? Thanks for the help

---

Eli, Eli. Eli....

Sure. Create a number field called "validation", auto enter data = 1.

Have your other field validate against that field Validation.

After you enter the data, have the number changed from 1 to 0 by script. Thereafter, as long as the Validation field =0, the data in the other field can not be changed by the user. It could be changed by script in some instances.

HTH

Old Advance Man

[Vaughan]

I make a script, and attach it to the field on the layout (so the field is a button). The script is simply:

code:

---

Allow User Abort [off]

If [isEmpty(field)]

Go to Field [field]

Else

Exit Record/Request

End If

---

If the field is empty they can enter it. If it is not empty the script keeps bumping them out. Obviously this only works if the user cannot select another layout.

[Steven H. Blackwell]

Be sure to remove the field from the TAB order if you do this.

Old Advance Man

[Vaughan]

Ouch! I forgot about that... Thanks OAM.

[BobWeaver]

If you deselect the "allow entry into field" option, you don't have to worry about the tab key, but the Go to field script step will still work.

[Vaughan]

In my experience, if "allow entry into field" is unchecked, there is *no way* to enter the field.

Either way, the original post was about having control over data entry, not just locking users out.