Compare Dates

[Koulla]

Hello,

I have one field EstimateDeliveryDate that accept date in
format 3/1/2005 and I want to compare it with the system
current date. If EstimateDeliveryDate is before system
current date then to change the fontcolor to become red
else nothing to do.

How can I do that in code???

Pls help me!

Thanks in advance
Koulla

 

[Steve Schapel]

Koulla

You can use Conditional Formatting (see under the Format menu in design
view of your form) for the EstimateDeliveryDate textbox. In the first
Condition box, select 'Field Value Is', in the second box select 'Less
than', and in the third box, simply type Date() Then you can select the
colour required.