Text box won't lock

[Paul H]

I have a Social Security text box that won't lock. I've set the locked property to Yes, but you can still change or delete the number in the form. I've tested other boxes on the form and the same thing works there. I am leaving the box Enabled, partly for cosmetic purposes, but this should work. I've done it countless times before.





Puzzled,

[Paul H]

Dammit, found it. I had this code in the Form Load event which is exactly what I want, only manager (mgr) should be able to edit here. Myself, being a manager, kept the box from staying.

If gblUserClass = "Mgr" Then Me.SSN.Locked = False

Tempest in a teapot.

Paul