Display crosstab query result with conditional formatting

  • Thread starter Thread starter LBRT
  • Start date Start date
L

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
 
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
 
Back
Top