Conditional formatting on a control within a form in access 2010

Sue Tippett
Sue Tippett used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
how did you set the conditional formatting?

- select HoursQty then select conditional formatting

use expression is  [RateOnlyInd] = True , then click the enabled button
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015
Commented:
for conditional formatting, select the control(s) to format in design view. On the Format ribbon choose Conditional Formatting, then New Rule (or Edit Rule), choose Expression Is and then specify a rule like [fieldname] <> True -- then  click Enable (toggle to disable) as a conditional format

For the expression, you can join crieria such as [fieldname1] <> True AND [fieldname2] =True ... and so on ...
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
Top Expert 2015

Commented:
you're welcome ~ happy to help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial