max number of fields in a report

[Guest]

Hi, I am trying to build a report containing 120 fields of data. But I get an
error "too many fields in report" error when trying to create a report
maunally or with the wizard. What is the size limit?

 

[Graham R Seach]

Mike,

According to Help, the maximum number of controls and sections you can add
over the *lifetime* of a form or report is 754. If you have a lot of
controls on the report, and have been mucking about with it for a while,
it's possible you've exceded this number.

Create a new report, give it the same RecordSource, and copy over all the
controls. See if that fixes the problem.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[John Spencer]

Maximum number of fields in a report is 255 (That is the limit on a table or
a query).
Maximum number of controls in a report is 754 over the life of the report.

If you add a control, save the report, and then delete the control - one of
the "slots" has been used.

 

[Guest]

thanks v much, i may well have unwittingly exceeded the limit in this way.
I'll try again with a new report.

 

[Guest]

thanks, will do.

Mike,

According to Help, the maximum number of controls and sections you can add
over the *lifetime* of a form or report is 754. If you have a lot of
controls on the report, and have been mucking about with it for a while,
it's possible you've exceded this number.

Create a new report, give it the same RecordSource, and copy over all the
controls. See if that fixes the problem.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia