Colour coding individual records

I work in education and store student performance in an access database and
would like to know how to colour code individual records in each field. For
examaple, I wish to identify the performance of each student in each subject
they study as either, green, amber or red. Unfortunately at the moment I can
change the colour of the whole field to red or amber or green but not
individual records within the field. So for example, pupil A's performance in
English is coloured red, in Maths it is coloured amber and in Science it is
coloured green and so on.

Apologies if I have not made myself clear enough.

Regards

Use Conditional Formatting with A2K or higher.

--

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


"scowden" wrote in message
...
I work in education and store student performance in an access database and
would like to know how to colour code individual records in each field.
For
examaple, I wish to identify the performance of each student in each
subject
they study as either, green, amber or red. Unfortunately at the moment I
can
change the colour of the whole field to red or amber or green but not
individual records within the field. So for example, pupil A's performance
in
English is coloured red, in Maths it is coloured amber and in Science it
is
coloured green and so on.

Apologies if I have not made myself clear enough.

Regards

Stephen

Thanks for your reply. Unfortunately I am unfamiliar with the terms, A2K or
higher. If it is possible could you clarify what I need to do.

Regards

"Stephen Lebans" wrote:

Use Conditional Formatting with A2K or higher.

--

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


"scowden" wrote in message
...
I work in education and store student performance in an access database and
would like to know how to colour code individual records in each field.
For
examaple, I wish to identify the performance of each student in each
subject
they study as either, green, amber or red. Unfortunately at the moment I
can
change the colour of the whole field to red or amber or green but not
individual records within the field. So for example, pupil A's performance
in
English is coloured red, in Maths it is coloured amber and in Science it
is
coloured green and so on.

Apologies if I have not made myself clear enough.

Regards

Steve is saying you can use the Conditional Formatting property if you are
running Microsoft Access (2000) or Newer (A2K or Higher). If you are still
running MicroSoft Access 95 or 97 you have to do some other workaround.

Ed Warren.

"scowden" wrote in message
...
Stephen

Thanks for your reply. Unfortunately I am unfamiliar with the terms, A2K
or
higher. If it is possible could you clarify what I need to do.

Regards

"Stephen Lebans" wrote:

Use Conditional Formatting with A2K or higher.

--

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


"scowden" wrote in message
...
I work in education and store student performance in an access database
and
would like to know how to colour code individual records in each field.
For
examaple, I wish to identify the performance of each student in each
subject
they study as either, green, amber or red. Unfortunately at the moment
I
can
change the colour of the whole field to red or amber or green but not
individual records within the field. So for example, pupil A's
performance
in
English is coloured red, in Maths it is coloured amber and in Science
it
is
coloured green and so on.

Apologies if I have not made myself clear enough.

Regards