adding color to datasheet view

[Guest]

I have a form (actually a subform) that displays the records in datasheet
view. On any record that has a date that's older than the current date I
would like to change the background color to the something like red for that
date field for that record. Is there a way to do this?

Cheers,
Jon

 

[Guest]

Go into Design View on the form and look at Conditional Formatting under
Format in the toolbar. I had the exact same need; works great!

 

[Guest]

Works perfect. Thank you!

Go into Design View on the form and look at Conditional Formatting under
Format in the toolbar. I had the exact same need; works great!