Jade5 said:How can I click on a checkbox to indicate that a company has closed and then
automatically turn all fields in the form grey while still being able to see
the data in the fields.?
Marshall Barton said:Jade5 said:How can I click on a checkbox to indicate that a company has closed and then
automatically turn all fields in the form grey while still being able to see
the data in the fields.?
You can use Conditional Formatting on each of the controls
you want to disable. Use the Expression Is option and set
the exprssion to
[nameofcheckbox]
then unselect the Enabled property.
I understand what you mean by setting conditional formatting on the controls
I want to disable but how do I use the Expression Is option? I checked the
properties dialog box but could not find it so I must be looking in the wrong
place.
Marshall Barton said:You can use Conditional Formatting on each of the controls
you want to disable. Use the Expression Is option and set
the exprssion to
[nameofcheckbox]
then unselect the Enabled property.
Marshall Barton said:When you're looking at the CF window, on the left side under
the word Condition, you see a drop down box that says Value
Is. Just select Expression Is option from the list instead
of the Value Is.
--
Marsh
MVP [MS Access]
I understand what you mean by setting conditional formatting on the controls
I want to disable but how do I use the Expression Is option? I checked the
properties dialog box but could not find it so I must be looking in the wrong
place.
Jade5 wrote:
How can I click on a checkbox to indicate that a company has closed and then
automatically turn all fields in the form grey while still being able to see
the data in the fields.?Marshall Barton said:You can use Conditional Formatting on each of the controls
you want to disable. Use the Expression Is option and set
the exprssion to
[nameofcheckbox]
then unselect the Enabled property.