Access - Using VBA to lock a column

Using VBA, how do I change the properties of a field to locked?
SharonInGeorgiaAsked:
Who is Participating?
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
Me.YourFieldName.Locked = True

{related}

Me.YourFieldName.Enabled = False
0
 
Jeffrey CoachmanMIS LiasonCommented:
SharonInGeorgia,

(No Points)
also related...
Set the "Locked" property of the control to Yes, if you want it to be locked automatically, when the form opens.

JeffCoachman
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.