Any one any good at microsoft office Access database please

[PaulaSB12]

I have a database set up, one of the forms is in the form of a yes/no answer. I want to make it so that if the answer of the form is no then the row colour is red, but if the answer is yes the row colour is green does anyone know how to do this?

 

[NotInThecity]

Used to work in Access a lot...

Where is the 'row' you are referring to? Is it on the form or in a report? Is the form in a datasheet format?

Also, are you familiar with VBA at all? It is where you can do the major stuff for forms/reports/etc on Access (and other MS programs).

Need a bit more info and I will try to help if I can!