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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Once date is entered into a field lock the field for read only 2
Lock fields in subform except two after authorization date is ente 3
Lock a field after data entry so value cannot be changed 2
Restrict memo field to size of text box 2
Date Stamping & Protecting a Comment Field 5
Change label if record exists 2
Locking a record without using the new record feature. 3
Text box and "Enter" 2

Back
Top