Locking and Unlocking Fields on a Form
Hi,
I have a form the most of the time needs to be read only.
Up 'til now I have locked all the text boxes.
The users have been able to unlock a particular field by clicking a button that toggles the Locked property for that text box.
I now want to unlock all the fields by the click of one toggle button. What's the best way to do this?
a) Using the Allow Edits property instead
b) Looping through the text boxes (but I don't know how)
c) Setting each control to unlocked one at a time.
d) another way
Cheers
I have a form the most of the time needs to be read only.
Up 'til now I have locked all the text boxes.
The users have been able to unlock a particular field by clicking a button that toggles the Locked property for that text box.
I now want to unlock all the fields by the click of one toggle button. What's the best way to do this?
a) Using the Allow Edits property instead
b) Looping through the text boxes (but I don't know how)
c) Setting each control to unlocked one at a time.
d) another way
Cheers
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
/gustav