"Microsoft Office Can't Find The Field <field_name> referred to...

G

Guest

"Microsoft Office Can't Find The Field <field_name> referred to in your
expression"

My basic aim is to compare two numeric values, and colour code the reports
results accordingly.

The report generates fine until I add conditional formatting then I get the
error mentioned above.
The strangest part is that it applies the colour coding anyway (and
correctly) however one of the fields shows as "Name?" all through the report.
Remove the conditional formatting and all values show correctly again!

Any suggestions welcome, It's driving me mad!

Thanks in advance!
 
G

Guest

I should probably add that the conditional formatting is not being applied to
either of the fields being compared. It is intended to be applied to another
field of the same record.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access VBA error "Microsoft Access can't find the field '|' referred to in your experssion" 0
Access VBA error "Microsoft Access can't find the field '|' referred to in your experssion" 0
Failing to print fill colour of conditional formatting 1
can't find the field '|' referred to in your expression 5
"...can't find the field 'FieldName' referred to in your expressio 4
Tip - Possible fix for "Microsoft Office Cant Find the Field 'X' referred to in your expression" err 6
ErrorMsg: Can't find the field 'Forms' referred in your expression 1
Conditional Formatting of field with running sum of time 4

Top