I want to change the field properties on a continuos form put only for fields that display a certain value. For example, I have a continous form displaying 20 rows, a Yes/No field could be "N" and i want the background colour on these feilds to be Red, otherwise (i.e. = "Y") the bacground should be white.

Any ideas on how to achieve this?

Thanks in advance.

HiArt

If you're using Acc 2000 open your form in the design view, in the menu Format there's an option called "special formatting" - or something similar -(I'm working on a German system and translating the tech. terms is not always spot on). Here you can set the format to a different background colour dependant on the value of the field

Hope this helps

Marion

It's called "Conditional Formatting" and it workd great for your purposes.

Thanks for the Translation Zunan!
I try and note them as I go along.
Marion