I have an Access 2000 Database to track employee training. One of the fields lists the expiration date of a given course. I want to highlight the dates that are within 30 days of expiration with a yellow background (or text color) and past due dates with a red background (or text color) in my reports. Anybody got some code examples to share?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Code to change the background color of a textbox in a report
- Thread starter Silkydog
- Start date
check out conditional formatting as suggested by RoyVidar in your cross-post in the Forms forum
=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)
Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com
=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)
Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question