By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,946 Members | 723 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,946 IT Pros & Developers. It's quick & easy.

Conditonal formatting

P: n/a
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

Aug 17 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Aug 17 '06 #2

P: n/a
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

Aug 17 '06 #3

P: n/a
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

Aug 18 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.