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]=[Rate
[HoursQty].[Enabled]= ([RateOnlyInd] = True)
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]=[Rate
[HoursQty].[Enabled]= ([RateOnlyInd] = True)
Microsoft Access
Last Comment
crystal (strive4peace) - Microsoft MVP, Access
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you both for a quick response. Time constraints sometimes cause lapse in memory.
you're welcome ~ happy to help