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]

On Tue, 22 Jul 2003 19:40:48 -0700, "cuteisme"
<christy.tai@fsd.com.my> wrote:

>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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
[url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]

[Stephen Lebans]

Lookup ConditionalFormatting in Access Help.

--

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


"cuteisme" <christy.tai@fsd.com.my> wrote in message
news:829c01c350c3$d346e770$7d02280a@phx.gbl...

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