max number of fields in a report

M

mike C

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?
 
G

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
 
J

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.
 
M

mike C

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

mike C

thanks, will do.

Graham R Seach said:
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
Click to expand...
 
Top