O
othermail
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.
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.