Tabular form text box colors

[avarusbrightfyre]

Hello,



I'm trying to use a tabular form that displays current projects and I want to be able to highlight projects that are withing 14 days of being due. I would like to set it up so that projects that are outside the 14 days have a background color of white, and the projects that are within 14 days have a background color of red. Here is what I have so far:

Private Sub Form_Load()
If Me.MIL_DATE < Date + 14 Then
Me.MIL_DATE.BackColor = vbRed
Else
Me.MIL_DATE.BackColor = vbWhite
End If
End Sub

When I have a project that is within 14 days, this code turns all the text boxes for the "Mil_Date" column red, instead of just the one for entries within the 14 day window. Is there a way to tell Access that I want only the ones that are within 14 days to appear red, or am I limited because it's a tabular form?

[pbaldy]

The easiest way to accomplish this is with Conditional Formatting. Select the textbox you want to format in design view and select Format/Conditional Formatting and play with the settings there.

[avarusbrightfyre]

That worked great! Things you don't learn when you figure things out yourself..... Thanks!

[pbaldy]

No problemo; there are so many features that I don't think anybody knows them all, even the folks who wrote Access.