J
Josue R.
I have a datasheet form where the orders are displayed, from this list I
need to put on red color orders where daterequired for completion has
expired. I tried the following
If DateDiff("d", DateRequired, Date) >= 1 Then
DateRequired.BackColor = RGB(255, 0, 0)
Else
DateRequired.BackColor = RGB(255, 255, 255)
End If
This instruction works great with Form View, but as soon as I changed the
form to datasheet form the background doesn't change the color.
Any idea ?
Josue
need to put on red color orders where daterequired for completion has
expired. I tried the following
If DateDiff("d", DateRequired, Date) >= 1 Then
DateRequired.BackColor = RGB(255, 0, 0)
Else
DateRequired.BackColor = RGB(255, 255, 255)
End If
This instruction works great with Form View, but as soon as I changed the
form to datasheet form the background doesn't change the color.
Any idea ?
Josue