I have been researching this for some time now but haven't received any sound advice on whether it is faster to perform formatting on text boxes in a report via VBA or the built in Conditional Formatting. Does anyone have any suggestions as to whether one is faster than the other?
The reason I ask this is that I have a report with quite a few text boxes that currently all have some sort of Conditional Formatting on them (Not all have the same Conditional Formatting). I know that when you only have a few controls that require Conditional Formatting, the built in solution in Access 2007 should be sufficient, however when the number of controls grows and when the report has multiple records that require each control to be handled on each record, the Conditional Formatting becomes painfully slow (much like receiving 1000 paper cuts) and renders the report as pointless considering a user must run it for 10's of minutes to an hour to complete.
So, with that said, I am really just looking for anyone's suggestion as to whether I should invest some time in the VBA coding to do what the Conditional Formatting does, or do I just go back to the requestor and let them know that formatting all these fields is too much for the system to handle. Any response will be greatly appreciated, thanks!