Conditional Formating on Multiple Fields (1 Viewer)

[sychoangel]

Hello,

I have a report that has about 50 fields... I need any fields that have been left blank to be shaded.

I am able to Set a field to shade grey by going into conditional formatting:
Expression Is IsNull([FieldName])
And select Grey from the paint bucket


Is there any way to do this on multiple fields at once, or do i have to go in field by fiield and set it manually.


Thanks in advance
Sych

 

[Galaxiom]

You can apply the conditional formatting in a loop using VBA in design view and then save it. It would be a good project to work out how to do this but it might be quicker to just do it manually.

I know how it is done in a form and I expect it would be similar in a report. Do you have any VBA experience?