How to Customize datasheet view

C

cuteisme

My form is set to datasheet view. A column is MyDate. How
do I show the records with a date before today is in
yellow color, and the records with a date after today in
green?
 
J

John Vinson

My form is set to datasheet view. A column is MyDate. How
do I show the records with a date before today is in
yellow color, and the records with a date after today in
green?
Click to expand...

You can't. Datasheet forms don't give you much flexibility at all.

You can create a Continuous Form and use conditional formatting to do
this, though.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unremovable horizontal scroll bar on subform 1
Conditional formatting dates 3
Continuous Form: Change the color of one row 1
Subtracting two cell dates and highlight if over due by a certain amount of days 0
Default Conditional Formatting Grayed Out in Subform? 2007 0
adding color field 1
datasheet view 3
Datasheet View 3

Top