Conditonal Formatting

#1

I have a list of codes in a Continuous Forms where I want certain
codes to light up in a different colour shade.

The expression I came up with in the conditional format was:
[code]="A1" And "A2" And "A5" And "A21" And "A32"

I've tried : , ; Or instead of the And in the formula, but without
success anybody have any ideas? sure its simple really, please help.

#2

John wrote:

Quote:

I have a list of codes in a Continuous Forms where I want certain
codes to light up in a different colour shade.

The expression I came up with in the conditional format was:
[code]="A1" And "A2" And "A5" And "A21" And "A32"

I've tried : , ; Or instead of the And in the formula, but without
success anybody have any ideas? sure its simple really, please help.

How could, even if the syntax were correct, be in all of those.
Wouldn't OR be more correct?

Would Instr(" A1 A2 A5 A21 A32 ",code) > 0 work?

#3

John wrote:

Quote:

I have a list of codes in a Continuous Forms where I want certain
codes to light up in a different colour shade.

The expression I came up with in the conditional format was:
[code]="A1" And "A2" And "A5" And "A21" And "A32"

I've tried : , ; Or instead of the And in the formula, but without
success anybody have any ideas? sure its simple really, please help.

Here's an easier way:

Select the Expression Is option and use an expression like:
[code] IN ("A1","A2","A5","A21","A32")
--
Marsh

#4

Thanks for all your help the formula works great.

On Mar 24, 9:42*pm, Marshall Barton <marshbar... (AT) wowway (DOT) com> wrote:

Quote:

John wrote:
I have a list of codes in a Continuous Forms where I want certain
codes to light up in a different colour shade.

The expression I came up with in the conditional format was:
[code]="A1" And "A2" And "A5" And "A21" And "A32"

I've tried : , ; Or *instead of the And in the formula, but without
success anybody have any ideas? sure its simple really, please help.

Here's an easier way:

Select the Expression Is option and use an expression like:
* * * * [code] IN ("A1","A2","A5","A21","A32")
--
Marsh

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Conditonal Formatting

comp.databases.ms-access comp.databases.ms-access

Conditonal Formatting - 03-24-2009 , 03:06 PM

Re: Conditonal Formatting - 03-24-2009 , 03:33 PM

Re: Conditonal Formatting - 03-24-2009 , 03:42 PM

Re: Conditonal Formatting - 03-24-2009 , 04:33 PM