microsoft.public.access.forms

Bill,
Well, I don't see why your conditioning isn't applying properly. Your
expressions appear to be correct.
I just whipped up a little form to test your expression, and it worked
just fine.
(always Refresh on the AfterUpdate event of Missing and Deceased)

Would you send me the file?
Zip and send to my Contact on my website below.
In that email, please use "AccessNG" in the subject.
Indicate what version of Access, and exactly what form the problem
relates to.
No charge-confidentiality ensured...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."


"Bill" wrote in message
news:6fSdndLqkrUhg6DanZ2dnUVZ_gydnZ2d@trueband.net...
> Al,
>
> The controls, tblastname and tbfirstname are the controls
> bound to an individual's name and it is to those fields that
> the conditional formatting is applied. "Deceased" and
> "Missing" are two True/False fields in the RecordSource
> that indicate whether the name in the current record are
> either missing or deceased. I simply want the name fields
> to display in different colors when those conditions apply.
>
> Bill
>
>
> "Al Campagna" wrote in message
> news:OF65pcAKIHA.4808@TK2MSFTNGP05.phx.gbl...
>> Bill,
>>> controls on a continuous form, where "missing" and
>>> "deceased" are in the fields collection of the RecordSource query.
>>
>> Are you saying that the 2 text controls contain "Missing" in one, and
>> "Deceased" in the other?
>> Are they bound fields, and what are the names of those text controls?
>> Why are you using text controls for a boolean value? I would think
>> Missing & Deceased would be True/False fields, each using a checkbox to
>> set it's value.
>>
>> Sounds like your expressions both always equate to True. So whatever
>> the last statement is... it gets that color.
>> I'm probably misunderstanding. From what I gather from your post...
>>> 1st cond: Expression is --- [Field1] = "Missing" Red
>>> 2nd cond: Expression is --- [Field2] = "Deceased" Blue
>> should do it.
>> --
>> hth
>> Al Campagna
>> Microsoft Access MVP
>> http://home.comcast.net/~cccsolutions/index.html
>>
>> "Find a job that you love... and you'll never work a day in your
>> life."
>>
>>
>> "Bill" wrote in message
>> news:94idnVHll8mKmaDanZ2dnUVZ_qelnZ2d@trueband.net...
>>> Shouldn't this conditional formatting work? (CF
>>> applied to a text box on a form.)
>>>
>>> 1st cond: Expression is --- [Missing]=True Red
>>> 2nd cond: Expression is --- [Deceased]=True Blue
>>>
>>> Only the second of the two specifications takes effect.
>>> If I reverse them, once again it's only the 2nd spec that
>>> effects display.
>>>
>>> The conditional formatting is specified on two text box
>>> controls on a continuous form, where "missing" and
>>> "deceased" are in the fields collection of the
>>> RecordSource query.
>>>
>>> This exact conditional formatting specification works
>>> perfectly on a Report that uses the same un-filtered
>>> query and similar text boxes.
>>>
>>>
>>>
>>
>>
>
>