VBA to conditional format report controls

[CJ_London]

I still don't know how to code the conditional formatting VBA

see post #3, but this is a one time exercise. why spend 3-4 times as long developing and testing code you are going to use once.

[hehrerh]

In Detail section Format event set control properties. Like:

Me.controlname.FontBold = <your criteria that evaluates to true/false>

So if you have 60 controls and you want to manage 4 property settings - well you do the math on how many lines of code to write.

Frankly a simple loop, 20 or 30 lines max, would accomplish this. You don't need code for each field just a routine that runs for every text control on the report.

[CJ_London]

I presume that is a statement, not a question - example code has been provided

I don't believe I can help further so good luck with your project

[June7]

Yes, I expect a loop could be employed. It would require a structure that addresses only textboxes. More than one way to accomplish. Do you have code? If not, iterating controls has been topic of numerous discussions. Do research and when you have code with specific issue, post question.

Ajax, the code would run every time report opens.