Problem with Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all.

I am running Access 2002, and I am working with an Access 2000 DB. I have created a simple report that pulls 14 records from a joined query. Within the report, I have setup Conditional Formatting for several of the numeric fields to show the text in RED if the value is less than some threshold. This works great. BUT, as soon as I put any conditional format on a text field, I get the #NAME? value in every row of the report (in the field that has the conditional format). I can put any expression/value-is value in the format dialog, but nothing will remove the #NAME? problem.

Any ideas as to why this isn't working?

Thanks in advance
Kevin
 
I sounds like you need to rename the text boxes, these
most likely have the name of the variables which is fine
as long as that is all you put in the text box. As soon
as you change the content of the text box you must rename
the box name.
Hope this helps.
Fons
-----Original Message-----
Hello all.

I am running Access 2002, and I am working with an Access
Click to expand...
2000 DB. I have created a simple report that pulls 14
records from a joined query. Within the report, I have
setup Conditional Formatting for several of the numeric
fields to show the text in RED if the value is less than
some threshold. This works great. BUT, as soon as I put
any conditional format on a text field, I get the #NAME?
value in every row of the report (in the field that has
the conditional format). I can put any expression/value-
is value in the format dialog, but nothing will remove the
#NAME? problem.
 
Back
Top