how do i write this

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

Guest

If the date is bigger than todays date and the task is complete, I want to
change the back colour to ..........

I think it is something along these lines:

If [Task Cmp] = true
and
if the [Sep] > date()
then
ContractorName.BackColor = 16764057
Else
ContractorName.BackColor = 255


thanks for the help,
pete
 
Something like this maybe:

If Me.Task_Cmp And Me.Sep > Date() Then
ContractorName.BackColor = 16764057
Else
ContractorName.BackColor = 255
End If
 
Got it on the end with this;

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If Me.Task_Cmp Or Me.Start_Date > Date Then
Me.Contractor_Name.BackColor = vbWhite
Else
Me.Contractor_Name.BackColor = 255
End If
End Sub


thanks so much for the help everyone, fiished!!
enjoy the weekend

Dan Artuso said:
Something like this maybe:

If Me.Task_Cmp And Me.Sep > Date() Then
ContractorName.BackColor = 16764057
Else
ContractorName.BackColor = 255
End If

--
HTH
Dan Artuso, Access MVP


Little pete said:
If the date is bigger than todays date and the task is complete, I want to
change the back colour to ..........

I think it is something along these lines:

If [Task Cmp] = true
and
if the [Sep] > date()
then
ContractorName.BackColor = 16764057
Else
ContractorName.BackColor = 255


thanks for the help,
pete
Click to expand...
Click to expand...
 
Back
Top