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.

Kimberly · #2 01-07-2011, 08:37 AM

Quote:

dates in the date field are not equal to or greater than the date displayed

The "date displayed"?

iffy · #3 01-07-2011, 09:44 AM

sorry I meant current date

iffy · #4 01-08-2011, 08:41 AM

take it there is not any way to achieve this?

iffy · #5 01-16-2011, 04:42 AM

Ok i will make it a little more straight forward. I just want an expired date to be very obvious.

Matrix · #6 01-16-2011, 06:28 AM

If it's an Access question, please post it on the access forum.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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