Conditional Formatting on a partial Field

[JamesBBB]

Hi There
Im havving a little problem with conditional formatting. Im not sure if its just me!!
Basically on a continuous form there are some records that contain (Incomplete) in the field name. ie

records:
Testing Project
Stress Project
Finalization Project
Release Project(Incomplete)
Sign off(Incomplete)

I would like to conditionally format those records that contain the phrase (Incomplete) in red and Bold.

I have tried using in the conditional formatting dialog
expression is "*" & "Sign off(Incomplete)" & "*"
but it does not work.

Is what I want to do possible and if so, can anyone show me what Im doing wrong

Many thanks

James

 

[Remou]

You say "(ncomplete) in the field name" ... this seems odd. Do you mean that a textbox control equals "(incomplete)" in some cases? Please explain a little more.

 

[TheAceMan1]

How are ya JamesBBB . . .

Perhaps:

[blue]   [Release Project] = "Incomplete"
or
   [Release Project] Like "*ncomplete*"[/blue]

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[JamesBBB]

Thanks Remou, for having a look at my problem, however I have just this minute solved it.

I stated above

expression is "*" & "Sign off(Incomplete)" & "*"

what I should use is as follows:-

expression is [Title] like "*" & "Sign off(Incomplete)" & "*"

It works now.

Just a stupid mistake on my part.

Thanks again though.

James

 

[PHV]

expression is: Like "*(Incomplete)*"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886