Using Yes/No data to fill a box with a color on a report

[evand]

This is a ludicrous question, and I know it. Is there a way when generating a report to have boxes fill in with color if a yes/no option is yes in the table?



I am trying to make tags that show an employee's name and specific colors if they possess identified skills. What I REALLY want would be for the boxes to change size and auto-center depending on how many options are true so that they always take up the same amount of space. I can make this work as a one time thing in Publisher to get my tags, but I would really like to have updatable reports for it.

[pbaldy]

The color part is easy, can be done with Conditional Formatting. The size part is probably doable, with VBA code in the format event of the report section containing the boxes. I suspect it will more tedious than difficult. You have to anticipate all the possibilities and account for them. I suppose you could also use hidden textboxes, and make the appropriate ones visible based on how many options are true.