Conditional Format

[Guest]

Hello.
I have a subform with the following fields:
ScheduledTimeFrame
ActualLoginTime
ActualLogoutTime

I need to add Conditional formatting to show something like:
If current time is greater than "ActualLoginTime" and "ActualLogoutTime" is
greater than the current time or is Null then turn blue.

Is this possible?

Your help is greatly appreciated.
Iram/mcp

 

[grep]

Something like this?

if ((Now() > ActualLoginTime) AND (ActualLogoutTime < Now()) then
FieldName.backcolor = 15251596
else
FieldName.backcolor = -2147483643
end if

where FieldName is the name of the field you wanted to change (You
didn't say what it was). Something like that anyway.

grep