[AccessD] Conditional Format Question

Hi Jim:

It would not be as simple as field.text (what displays) and field.value
(what the field value was). Barring that it may be that the field stored
value is represented as a string and is not comparing with date value or the
formatting is different. Have you tried something like? :

If format(me.field.value,"yyyymmdd") < format(now(),"yyyymmdd") then bold
field.

HTH
Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht
Sent: January 15, 2006 8:58 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Conditional Format Question

I have series of date fields that represent license
expiration dates.

 

I have tried to do a conditional format where 

 

            If field value < now () bold the field

 

Where field value is the expiration date.

 

Nothing happens to the field.

 

Any ideas?

 

 

 

 

Joe Hecht

jmhecht at earthlink.net

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com