subform

  • Thread starter Thread starter Maggie
  • Start date Start date
M

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
 
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.
 
Back
Top