Code not working in setting conditional formatting

[rew2009]

I have field that I want to change the formatting of when the condition is met whereby a separate field named “Street” has the value “MAIN ST”.

All the records with this content are between ID = 49934 and ID = 50575. The conditional formatting works when I use [ID]>49933 And [ID]<50528 in the condition "1" expression box.

However when I use [Street]="MAIN ST" in the same condition box it does not work. I get no error, but nothing happens. Is my syntax wrong?

What are your thoughts?

Thanks

 

[MajP]

[ID]>49933 And [ID]<50528 AND [Street]="MAIN ST"

It is a little unclear what you are checking. But this works.

 

[TheAceMan1]

How are ya rew2009 . . .

Try:

[blue][Street] Like "*MAIN ST*"[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]