how to display expired date in red (access)

iffy · #1 01-07-2011, 05:48 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Name - Display Name	Jamal NUMAN	Outlook	2	11-21-2010 09:52 PM
Date display in Mod quick part header	Jrul John	Word	1	08-02-2010 12:17 PM
Access 2007 Upgrade After Initial Install - Access 2003 Won't Remove	wcb	Office	1	01-25-2010 04:08 AM
new appointment date always reverts back to today's date	msills	Outlook	0	08-24-2007 08:57 AM
Imported message date change to today's date	promark	Outlook	1	12-23-2005 07:21 AM