Change the colour in text in a sub form

[jon]

Hi
I want to change the colour of text in a sub form so that records where the
data is over due will be red and where the data due this week is in orange
and all the rest is black.

there are five fields in each record and all want the colour changing so
each record has the correct colour.

So where would I put the code and can some one help with the code please.
I think I would be using an if statement

I have the code which will select over due components
"<Date()-Weekday(Date(),0)+7 "
and 2 fields names are
orderNo
Job


Thanks

Jon

 

[Pat Hartman]

For continuous forms or datasheet forms, you need to use the Conditional
Formatting (found on the Format menu). Use the same expression for all the
fields if you wand all the fields to change color.

 

[jon]

Hi Pat

I cant find the Conditional Formatting .
I am using access 97 so I think that will make difference.
Do I need to make an event for a field?

Jon

 

[Pat Hartman]

Conditional formatting did not exist in A97 so your eyes are not going bad.
you need to change the colors in code. If you search the web or the MS
knowledgebase, you might come across a method that involves placing controls
with the different attributes and transparent backgrounds on top of each
other. Sorry, that's all I remember about the technique. A97 was a
fantastic version of Access but perhaps it is time to step up to A2003 if
you are not prepared to go all the way.

 

[jon]

ok thanks

Jon

Conditional formatting did not exist in A97 so your eyes are not going
bad. you need to change the colors in code. If you search the web or the
MS knowledgebase, you might come across a method that involves placing
controls with the different attributes and transparent backgrounds on top
of each other. Sorry, that's all I remember about the technique. A97 was
a fantastic version of Access but perhaps it is time to step up to A2003
if you are not prepared to go all the way.