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
Thanks so much for the speedy reply - I feared as much. LBRT
