Display crosstab query result with conditional formatting

[LBRT]

I have read several posts here but none [so far] seem to answer this question
of mine.

I have a crosstab query: shows all kids alpha sorted in four grade levels
nested within four schools - next to each kid's name are three columns,
showing test results for three points in time during the school year.

I would like to color the "passing" results in green, the failures in red,
and the close-misses in yellow.

I read here that I can display this query in a form in datasheet view - so
far, I have that -

I still cannot cause the different results to change color based on their
values.

Is this possible?

Thx in advance!

LBRT

 

[Lord Kelvan]

access is not a spreadsheet you cannot format the colour of text in
datasheet view you can set your form to continious forms and then
position the fields like a speradsheet and then change the fore colour
property but it has no effect in datasheet view

Regards
Kelvan

 

[LBRT]

Thanks so much for the speedy reply - I feared as much.

LBRT