adding color to datasheet view

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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!
 
Works perfect. Thank you!

vseale said:
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!
Click to expand...
 
Back
Top