Access Report - Too Many Fields
Posted on 2008-10-16
I have an access 2003 report that is ridiculously wide with a large amount of controls that's giving me a "Too Many Fields" error on preview. Here is the breakdown:
Page Header - 109 Labels, 4 Textboxes
Detail - 56 Controls
Report Footer - 5 Labels, 240 Textboxes
All 240 of the fields in the report footer have a Sum() expression in the control Source. If I remove 38 of the controls in the footer it runs fine. If I add back one control and remove the formula from the Control Source it runs fine. When I add back the formula, I get the error.
Compactin the DB
Rebuilding the report using cut and paste
I really need to get this report working. Any thoughts?