How do i use Conditional formatting for 3+ conditions ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roger - 14 Mar 2007 22:04 GMT

I have a text box in a report which highlights in colour current members in
a list of past and present member names. I have six types of current members
that I want to highlight, but with conditional formatting I can only use 3
conditions in the members [Type] field. I have tried [Type]="Full member" Or
"Life member" but the "Or" doesn't work ! Is there a way to do this ?

thanks .. Roger

Reply to this Message

Allen Browne - 15 Mar 2007 03:38 GMT

CF is limited to 3 contitions, but you can use OR in those expressions.

If you set Condition1 to Expression, you can use:
([Type] = "Full member") Or ([Type] = "Life member")

If that still doesn't work, open the table in design view, and see what kind
of field Type is. If it is a Number (using a combo to show the text), you
will need to put the correct numbers here instead of the text. And the
numbers don't go in quotes.

If you do end up needing more than 3 colors, and you are comfortable with
VBA code, you can set the BackColor of the text box in the Format event of
its section.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a text box in a report which highlights in colour current members in
>a list of past and present member names. I have six types of current
[quoted text clipped - 4 lines]
>
> thanks .. Roger

Reply to this Message

Jane - 22 Oct 2007 16:04 GMT

You need to include the field name each time.
if [Type]="Full member" Or [Type]="Partial Member" or [Type]="New Member"....
then
(Whatever you want to happen)
end if

Reply to this Message