<div>
I would use a) ... perhaps combined with AllowAdditions = False<br />
<br />
/gustav
</div>


I would use a) ... perhaps combined with AllowAdditions = False

/gustav

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a form the most of the time needs to be read only.<br />
<br />
Up 'til now I have locked all the text boxes.<br />
<br />
The users have been able to unlock a particular field by clicking a button that toggles the Locked property for that text box.<br />
<br />
I now want to unlock all the fields by the click of one toggle button. &nbsp;What's the best way to do this?<br />
<br />
a) Using the Allow Edits property instead<br />
b) Looping through the text boxes (but I don't know how)<br />
c) Setting each control to unlocked one at a time.<br />
d) another way<br />
<br />
Cheers
</div>
</div>


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

Locking and Unlocking Fields on a Form

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.