Greying Out Controls

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

Hi Guys,
I'm trying to get a control on a form to become greyed out when i tick a
check box.I know there's been a couple of threads on this before and i've
actually got it to work but when i open the form again the control is no
longer greyed out, even though the checkbox still has the check mark in it ??

Any help would be great,
Thanks everyone,
Jen
 
Hi Guys,
I'm trying to get a control on a form to become greyed out when i tick a
check box.I know there's been a couple of threads on this before and i've
actually got it to work but when i open the form again the control is no
longer greyed out, even though the checkbox still has the check mark in it ??

Any help would be great,
Thanks everyone,
Jen
Click to expand...

It would have been helpful for you to let us know what your code
actually is to "grey out" the control, so as not to just tell you to
do the same thing as is now not working.

The following should work.
You need top place the below code in 2 places.
Place this code in the Check Box AfterUpdate event as well as the
Form's Current event:

Me.[ControlName].Enabled = (Me.[CheckBoxName] = 0)

Substitute your actual control names.
 
Hi Fred,
Thanks for the reply. I tried your suggestion and it worked fine in the
AfterUpdate event of the check box, but when i put it the the Form's current
event and run it i get a message saying 'Run-time Error 94;' Invalid use of
Null.

Then when i click Debug i get the following code highlighted in yellow

Me.[Manager].Enabled = (Me.[Check39] = 0)

I tried this code with the square brackets in and out and neither worked

Thanks,
Jen
Hi Guys,
I'm trying to get a control on a form to become greyed out when i tick a
Click to expand...
[quoted text clipped - 5 lines]
Thanks everyone,
Jen
Click to expand...

It would have been helpful for you to let us know what your code
actually is to "grey out" the control, so as not to just tell you to
do the same thing as is now not working.

The following should work.
You need top place the below code in 2 places.
Place this code in the Check Box AfterUpdate event as well as the
Form's Current event:

Me.[ControlName].Enabled = (Me.[CheckBoxName] = 0)

Substitute your actual control names.
Click to expand...
Click to expand...

What happens if you use:

Me.[Manager].Enabled = (Nz(Me.[Check39] ,0)= 0)
 
Back
Top