subform

[Maggie]

How do I change the ForeColor of a field in a subform it
the data meets certain critera. For example: my user
wants the StartDate field color to change to yellow if the
StartDate is < Date().
When the main form is opened, do the events in the subform
then execute. Where would I put this code?
Thanks, Maggie

 

[Allen Browne]

1. Open the subform in design view.

2. Select the StartDate text box.

3. From the Format menu, choose Conditional Format.

4. Set Condition1 to:
Expression Is [StartDate] < Date()

5. Drop down the bucket icon, and click yellow.