What is the maximum number of fields allowed in an access report?

  • Thread starter Thread starter Sherrie
  • Start date Start date
S

Sherrie

I am trying to create a report, but get the error message that I have too
many fields. What is the maximum number of fields allowed in an access report?
 
Sherrie said:
I am trying to create a report, but get the error message that I have too
many fields. What is the maximum number of fields allowed in an access report?
Click to expand...


A table/query can have a maximum of 256 **fields** (columns)
so the report's record source has the same limit.

A form/report can have a max of 754 **controls** (text
boxes, labels, sections. etc). A subtle point with that is
when you delete a control, Access does not reclaim the space
used by the deleted control. You can force the space to be
reclaimed by Copy/Paste the form/report or probably just
using Compact or several other less obvious methods.
 
255 fields in a report
754 controls in a report

You can actually get more than that by using a sub-report which has the
same limits. So your main report could have 255 fields and a sub-report
included on the main report could have an additional 255 fields. Of
course some of the fields on the sub-report would have to be identical
to a field or fields in the main report. You need that so you can link
the sub-report to the main report.

I would HATE to be the person that needed to use a report with this many
different fields.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Back
Top