Conditonal formatting

[sycosyxx via AccessMonster.com]

I have created a form to display a list of students that need to be scheduled
to drive. One of the fields that I am using in my table is the studeNts birth
date. I would like to use conditional formatting to highlight that field for
a certain range of months, but I am not very good at working with code as of
yet. Can anyone give me a hand?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200608/1

[jahoobob via AccessMonster.com]

Use Format, Conditional formatting on the menu. Select Field value and Is
between and then enter the first month and then the second month. Then
select the Font color and/or background color. BTW, select contrasting
colors - red font on black background is not evrey visible as are yellow and
white.

Know why Red on black is not easily seen? Black refect no light back that
the human eye can detect and red is at one end of the spectrum, getting close
to invisible infra red. Purple, at the other end of the spectrum, near ultra
violet is similar. This is a bigger problem the older the user.

sycosyxx wrote:

>I have created a form to display a list of students that need to be scheduled
to drive. One of the fields that I am using in my table is the studeNts birth
date. I would like to use conditional formatting to highlight that field for
a certain range of months, but I am not very good at working with code as of
yet. Can anyone give me a hand?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200608/1

[sycosyxx via AccessMonster.com]

jahoobob wrote:

>Use Format, Conditional formatting on the menu. Select Field value and Is
between and then enter the first month and then the second month. Then
select the Font color and/or background color. BTW, select contrasting
colors - red font on black background is not evrey visible as are yellow and
white.

Know why Red on black is not easily seen? Black refect no light back that
the human eye can detect and red is at one end of the spectrum, getting close
to invisible infra red. Purple, at the other end of the spectrum, near ultra
violet is similar. This is a bigger problem the older the user.

>>I have created a form to display a list of students that need to be scheduled
to drive. One of the fields that I am using in my table is the studeNts birth
date. I would like to use conditional formatting to highlight that field for
a certain range of months, but I am not very good at working with code as of
yet. Can anyone give me a hand?

Thank you very much for the help I was thinking it was more complicated then
this,
I should have been able to do that on my own, but I had a bit of a brain fart.
And thanks for the color input too, I have several older people working
in the office I am designing this for.

--
Message posted via http://www.accessmonster.com

[jahoobob via AccessMonster.com]

I am very familiar with brain farts.

sycosyxx wrote:

>>Use Format, Conditional formatting on the menu. Select Field value and Is
between and then enter the first month and then the second month. Then

[quoted text clipped - 12 lines]

>>>a certain range of months, but I am not very good at working with code as of
yet. Can anyone give me a hand?

Thank you very much for the help I was thinking it was more complicated then
this,
I should have been able to do that on my own, but I had a bit of a brain fart.

And thanks for the color input too, I have several older people working
in the office I am designing this for.

--
Message posted via http://www.accessmonster.com