Conditional Formatting

[donsi]

I have a report which has employee names, Status (check in/out) and the amount. When report is generated, it shows all day's activity of employee checking in/out items. I manage to format check in & out to two different colors, but I would like to add additional color coding for employees who checked out the item but never checked in. is it possible? and if so what expression would be used. I tried various IIF statements but doesn't produce the results I want.

txtboxes names: TxtEmp, TxtStatus & Txtamount.


Thanks in advance.

 

[Ranman256]

in the report band (detail or header) to change the color, put in the ON PRINT event:

select case true
    case txtBox1 = "OUT" and IsNull(txtCheckIn)
          txtbox2.backcolor = vbRed
    case txtBox1 = "OUT" and not IsNull(txtCheckIn)
          txtbox2.backcolor = vbYellow
    case txtBox1 = "IN"
          txtbox2.backcolor = vbWhite
end select

 

[donsi]

in the report band (detail or header) to change the color, put in the ON PRINT event:

select case true
    case txtBox1 = "OUT" and IsNull(txtCheckIn)
          txtbox2.backcolor = vbRed
    case txtBox1 = "OUT" and not IsNull(txtCheckIn)
          txtbox2.backcolor = vbYellow
    case txtBox1 = "IN"
          txtbox2.backcolor = vbWhite
end select

That worked like a charm. Thank you