Conditional Format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Iram - 08 May 2007 17:41 GMT

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

Reply to this Message

grep - 08 May 2007 17:59 GMT

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

> Hello.
> I have a subform with the following fields:
[quoted text clipped - 10 lines]
> Your help is greatly appreciated.
> Iram/mcp

Reply to this Message