View Single Post
 
Old 01-07-2011, 05:48 AM
iffy iffy is offline Windows XP Office 2003
Novice
 
Join Date: Jan 2011
Posts: 8
iffy is on a distinguished road
Default how to display expired date in red (access)

Hi guys, first post here. Glad I found this forum.

Anyway, I would appreciate if someone could tell me how display an expired date in red? For example: if the dates in the date field are not equal to or greater than the date displayed, I would like the expired date to be displayed in red. Another example - 12/12/10 should be displayed in red and 12/12/11 should remain in the default colour black. #

I hope I haven't confused anyone.
Reply With Quote