If null then Blue

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Iram said:
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.
Click to expand...


You can do a lot with Conditional Formatting (View menu) by
selecting the Expression is option. Try using an expression
something like:

[CurrentTime] > [ActualLoginTime] Or [CurrentTime] <
[ActualLogoutTime] Or IsNull([CurrentTime])

I have no idea what CurrentTime is, since it can't mean the
time on the clock, it must be something else. The above
supposes that it's a date/time value in a text box on the
form.
 
Back
Top