MS Access Report. Need to know how to change the fore & back color of one textbox based on the date range of a another text box. Use VBA or Conditional formatting?

1. Have a text box control (txtDueDate) in the detail section of my report with conditional formatting so if the date is between 9/1/2011 and Date()+90, it turns background yellow and fore Red.

2.  Have another control named txtDescription in the report detail area.

3.  Want the txtDescription row to also turn these colors when it falls between the date range of the txtDueDate

Looked on MS office help site where they claimed Conditional formatting would do this but don't know how to write the expression. Or, should this be done with VBA on Properties or Report Properties i.e. On Load, On Open etc.

Thank you,

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Joseph KrauszCEOCommented:
Just select the txtDescriprion and add the same expression you did on the txtDueDate. But you need to change the DropDown from "field" to "expression" so go to the conditional formatting instead of "field" choose "expression" and enter: [txtDueDate] between..... This should work for the txtDescription to become formatted.



Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
lynkskoAuthor Commented:
It worked!  Fantastic!

Thank you Joseph,

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.