Consditional Font Formats

[Belinda J.]

I am trying to change the color of the font on an entire line of a report if
one field meets certain criteria. When I insert the conditional formating
[EFFECTIVE] > 12/31/2005, it returns #name? in the field when you review the
report. I have tried every possible format for the date, with and without #
surrounding the date. Nothing works.

Please help.

thanks,

 

[Rob Parker]

Hi Belinda,

Do you have a control (probably a textbox) in your report which is named
"EFFECTIVE", and also a field in the report's recordset with the same name?
If so, change the name of the textbox to something else (txtEffective would
be a good name - it complies with the LNC naming convention), and your
problem should disappear.

HTH,

Rob