We help IT Professionals succeed at work.

Conditional formatting on a control within a form in access 2010

Sue Tippett
Sue Tippett asked
on
117 Views
Last Modified: 2018-02-02
In the detail section of the form, I want to disabled the control labeled "HoursQty" based on the control "RateOnlyInd" using a conditional formatting rule.

Controls on the form are:     ServiceTxt            RateOnlyInd     HoursQty     RateAmt
Data:
Service1            True
Service2            False
Service3            False
Service4            True
Service5            True

I have tried:
[HoursQty].[Enabled]=[RateOnlyInd]
[HoursQty].[Enabled]= ([RateOnlyInd] = True)
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
CERTIFIED EXPERT
Top Expert 2015
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Sue TippettData Modeler, DBA, DA

Author

Commented:
Thank you both for a quick response.  Time constraints sometimes cause lapse in memory.
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
CERTIFIED EXPERT
Top Expert 2015

Commented:
you're welcome ~ happy to help