Too much conditional formatting?

[Guest]

I created a report that lists the training dates for employees. I have set
up conditional formatting to change the background color and font style if
the training date is missing or expired. The problem is that when I add a
5th field with conditional formatting and try to preview the report, Access
"encounters a problem" and has to shutdown. If I remove the conditional
formatting on that one field I don't have any problems. Do I have too many
fields with conditional formatting? Is there anything I can do to fix this
problem?

 

[Stephen Lebans]

CF is not needed for Reports as the object exposes the Format event for
the relevant section. Simply programmatically manipulate the Control's
Backcolor and Font properties from the Format event.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.