<div>
Many thanks - works perfectly.
</div>


<div>
You're welcome, and Thnak You!
</div>


<div>
<div class="content wysiwyg-content">
Hi there - I'm working on an Access database and need to grey out (disable) a group of fields in a form based on whether the user clicks a check box or not - this is to stop records being accidentally altered when a case is closed. &nbsp;I can currently get fields to do this but when the form is closed and then reopened, the value is not saved, even though I have tried to save the value in another field. &nbsp;Any ideas?
</div>
</div>


Hi there - I'm working on an Access database and need to grey out (disable) a group of fields in a form based on whether the user clicks a check box or not - this is to stop records being accidentally altered when a case is closed.  I can currently get fields to do this but when the form is closed and then reopened, the value is not saved, even though I have tried to save the value in another field.  Any ideas?

How do I grey out fields in a form based on a checkbox in MS 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.