how to apply conditional formatting of one field to whole record

[FionaS]

Hi, I wish to change the background colour of record based on one of two
possible choices selected in one of the fields.

I have applied conditional formatting successfully to that field, but have
failed to find a way to apply the same format to the rest of the fields for
that record.

Thanks for all suggestions in advance.

Regards
Fiona

 

[Ken Sheridan]

Fiona:

Apply conditional formatting to each of the other controls using:

Expression is: [YourOtherField] = "Your choice"

If the other field is a Boolean (Yes/No) data type then the expression would
be:

[YourOtherField] = True

if the conditional formatting is to be applied for a 'Yes' (False for a 'No').

Ken Sheridan
Stafford, England

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ConditionalFormatting.mdb" which shows how to do several
different things with conditional formatting. You can find it here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=375

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L