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

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

"FionaS" wrote:

> 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

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/f...ts.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/...UBED1=ACCESS-L


"FionaS" <(E-Mail Removed)> wrote in message
news:0C19E501-F024-408B-BF61-(E-Mail Removed)...
> 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