Conditional Formatting is ignoring all conditions

Hello,

I am using Access 2003 on Win XP. I have a continuous form that has
several text boxes that are conditionally formatted based on their
value. What I am trying to do for this one text box is format the fore
and background color to display nothing (i.e. white) if its value is
the same as that of the previous record. Using a function I found on
the internet, I was able to do that. However, if I add more conditions
to the conditional formatting list for that textbox, Access ignores
_all_ of the conditions and displays the default formatting for that
field. Here is an example ([PreviousValue] is another textbox whose
source is set to the function that returns the previous value of a
field:

This works:
Condition 1:
Field Value Is Equal to [PreviousValue]


But this does not (reverts to default value):
Condition 1:
Field Value Is Equal to [PreviousValue]
Condition 2:
Field Value Is Equal to "any text"

Does anyone know why Access is ignoring all the conditions if I have
more than one, and/or how it can be fixed? This only happens if I am
using the function, but I would like to be able to use the function
with other formatting conditions as well. Thanks!

Please reply to newsgroup; e-Mail does not work.

Nevermind; I created another function that just returned the current
value of the field I was trying to format. Apparently, having that
type of expression and formula in a conditional format would not allow
me to have any other type of expression in the other conditionals if I
was referring to the field being formatted. Strange.

I'm not sure that is the problem. The condition you described as "any text"
means exactly that, so it is probably using the format for all records based
on that part of the condition.

" wrote:


Nevermind; I created another function that just returned the current
value of the field I was trying to format. Apparently, having that
type of expression and formula in a conditional format would not allow
me to have any other type of expression in the other conditionals if I
was referring to the field being formatted. Strange.