Data sheet view

[JoeAcess]

Hello once again


I use access 2007 If i have a subform which is in a datasheet view, can i have a row have specific colour according to a particular condition


Suppose a row has got a field called availability and if the filed is "yes", i want the row to show green else red. Can this be done. If so how?


Thanks

 

[JANR]

Lookup Conditional Format, however in access 2003 you cannot color the hole row only individual fields. Perhaps this has changed in 2007?

JR