Conditional Formatting on datetime field

[Delta729]

Okay, I'm sure this is pretty simple to do, but I've completely messed this up. I have a form that pulls in open project information that has a datetime field called "Duetime". What I'm attempting to do is that when this datetime field is less than 1 hour away, to turn the field background orange. Also, if less than 30 minutes to actually being past due, then it would be red.

Can someone help me out or point me to easy to understand article for this. I'm messing this up and getting this turned around in my head.



Thanks,
Dan

[ranman256]

You can't do it in a continuous form. ALL records get the same color.
it can only be done in a single record form.

If txtTime >[dueTime] then
txtTime.backcolor = vbRed
end if

[June7]

The criteria in Conditional Formatting would be like:

[Duetime] < DateAdd("h", 1, Now())

Would have to regularly refresh the form to get the calcs to update.

[Delta729]

OMG, thanks June. That did it. I was previously attempting Now()-....
This works perfectly.

I have this for the red.
[Duetime] < DateAdd("n",30,Now())

followed by this for the orange.
[Duetime] < DateAdd("n",60,Now())

Thank you so much again.