replace values with "indicators"

[JoeMap]

Hi all, first post here!

I have a table of information on construction projects. The table includes Project Number, Consultant, Contractor along with nearly 20 "date" fields. The table gets edited periodically when paperwork comes in that would update one of these fields.

I want to create a report that will show (for each record), the Project Number and either a red "X" for a null value (meaning there is information missing in the record for that field, or, a green check mark for a valid value. I've experimented with IIf statements with no success and thought about conditional formatting.

Ultimately, I will make a macro from it.



My vba experience is related to a little work with ArcGIS several years ago.

Thanks for any help.

JoeMap

[pbaldy]

In a report, you could use the detail format event to test your field value and make an image visible or not as appropriate (ie, make the X or the checkmark visible depending on the field). Conditional Formatting can't affect visibility (other than with font color manipulation), and I don't think it works with images anyway.

[JoeMap]

Still having issues with testing the value. I've been trying to the "IsNull" and similar ideas in the criteria field because my end goal is a report with the projects down the side and the "landmarks" or important dates at the top. The rest of the sheet would be red x's or green check marks.

Also can anyone tell me where to find a place to turn on an image in the details section. Or is that something I'll have to call with code? How can I make sure it'll do it for every record?

Thanks,

JoeMap

[pbaldy]

It is something you'll have to do in code, and like I said the detail format event would be the place. It fires for every record.