Link to home
Create AccountLog in
Avatar of Sue Tippett
Sue TippettFlag for United States of America

asked on

Conditional formatting on a control within a form in access 2010

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)
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Sue Tippett

ASKER

Thank you both for a quick response.  Time constraints sometimes cause lapse in memory.
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

you're welcome ~ happy to help