Protecting fields once data is entered

S

Sam

Hello

I have a couple of text boxes in my form that need to be locked once data is
entered so that it cannot be amended.

Can anyone assist??
 
C

Chris_h

You can set the locked property of the field to true OnLostFocus but this
might interfere with the usability of you form.

Chris
 
M

Marshall Barton

Sam said:
I have a couple of text boxes in my form that need to be locked once data is
entered so that it cannot be amended.
Click to expand...


Use the form's Current event to lock the controls:

Me.textbox.Locked = Not IsNull(Me.textbox)
 
Top