Continous Forms and Field Properties

[HiArt]

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

 

[MarionD]

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

 

[zunan]

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

 

[MarionD]

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