Change textbox forecolor in Tabular form

[bard777]

I am creating a project management DB for our company. I have a project form that has a requirements tabular subform. I want to change the due date textbox to red if the sue date has pasts.

I have been able to do this, but it seems to be evaluating the first value for this text box and setting the forecolor for all records instead of evaluating them individually.

Here is my code:

' Flag requirements past Due Date on Load
 
If Me.due_date < Date Then
    Me.due_date.ForeColor = RGB(255, 0, 0)
Else
    Me.due_date.ForeColor = RGB(0, 0, 0)
End If
 

I tried it in the On Load event (and several others).

This is not critical to the functionality of the DB, but it just seems like I should be able to do it...and, well, I am sure you know how that feels. :)

[bard777]

I figured it out....thanks to:

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

I used Conditional Formatting (on the Format menu in form design.) and just set the condition to "Less Than" and the value to "Now()".

[missinglinq]

For Continuous (Tabular) and Datasheet View forms you have to use Conditional Formatting off of the Format Menu in Form Design View.

1. Select the Due_Date textbox
2. Goto Format - Conditional Formatting
3. Select Expression Is
4. Then enter [Due_Date]<Date()
5. Select the ForeColor you want from the ForeColor Icon

Linq ;0)>