Check box to Grey out fields

[Guest]

Hello:
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.?
Thanks,
J.

 

[Marshall Barton]

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.

 

[Guest]

Thanks Marshall:
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.
Thanks,
J.

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.

 

[Marshall Barton]

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.

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.

 

[Guest]

Got it!! Thank you very much.
J.

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.?

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.