Set colors on specific rows in continuous form

[agust]

Can we set different colors on specific rows in a continuous form?
Suppose the following data entry form (continuous) is to fill in spouse name, while name and marital status is already prepared in a different table. If the marital status is Married, then the spouse name textbox's background color will be Yellow. The standard background color is white.

Name Marital Status Spouse Name
-------------------------------------
xxxx Married (Yellow)
xxxx Unknown (White)
xxxx Not married (White)
xxxx Married (Yellow)

 

[Pauldohert]

You could try an explanation ofsearching for "Conditional Formatting" which should do what you want I think. Can't remember what version this appears in but its certainly in XP.