The same applies to a
Datasheet View Form...which is likely to be the situation (assuming it's not in Continuous View) since your talking about coloring 'rows.' In that case you have to use the same advice, i.e. Conditional Formatting, but either use it to change the color of one Control, probably the Date Control, or to change the color of all Controls in the particular Record/Row.
You can do the Formatting of multiple Controls as easy a single Control.
In Design View
- Hold Down <SHIFT>
- Select each Control to be Formatted
- Click on Conditional on the Ribbon
- Under Contion1 drop down Expression Is
- In the next box enter you first expression
- Click on the Paint Bucket Icon
- Select the color for your first expression
- Click on Add
- Under Contion2 drop down Expression Is
- In the next box enter you second expression
- Click on the Paint Bucket Icon
- Select the color for your second expression
- Click on Add if appropriate...or OK if you're through.
Linq
:0)>