Protecting fields once data is entered

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
You can set the locked property of the field to true OnLostFocus but this
might interfere with the usability of you form.

Chris
 
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)
 
Back
Top