Visible Label on Condition

  • Thread starter Thread starter H
  • Start date Start date
H

H

I have two fields on a report that are times (Long Time
format), Time1 and Time2.

When the report is generated, if Time2 < Time1, I want to
place an '*' next to Time2.

I have no label or text box label next to the fields. How
can I accomplish what I want to do?
 
I have two fields on a report that are times (Long Time
format), Time1 and Time2.

When the report is generated, if Time2 < Time1, I want to
place an '*' next to Time2.

I have no label or text box label next to the fields. How
can I accomplish what I want to do?
Click to expand...

What do you want to show if Time2 is not earlier than Time 1?
Use an Unbound control.
Set it's Control Source to:
=IIf([Time2]<[Time1],[Time2] & "*",[Time2])
 
If the expression isn't true, I don't want to show the "*"
mark.

I will give your suggestion a try. Thanks.
 
Back
Top