Conditional Formatting + Hide Duplicates = #Name?

B

Badotz

Friends,

In Access 2003, if I set Hide Duplicates for a <job_number> to Yes, and
then apply Conditional Formatting based on the value of another field:

Expression is: [status_word]<>""

#Name? prints on the report instead of the value of <job_number>.

I have checked and double-checked field names; made sure the Control Source
(job_number) is not the same as the Name (txt_job_number); tried using
<txt_job_number> in the Conditional Formatting, all to no avail.

Any way around this conundrum?
 
Top