How to Customize datasheet view

[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?

 

[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?

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.

 

[Stephen Lebans]

Lookup ConditionalFormatting in Access Help.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.