Number of fields in report

D

Duane Hookom

Yes, there is a limit to the number of "controls" on both forms and reports.
I think it is about 754. You could search Help on "specifications" to find
all of these types of maximums.
 
L

Lisa R

754, I am trying less than 100 and the wizard generates a msg saying that i
should try the report with less fields.Any clue why this should happen with
Microsft Access 2003?
 
J

John Spencer

Because the wizard is limited.
You can have a maximum of 255 fields on a report (unless you resort to using
a subreport)
You can have a maximum of 754 controls on a report.

You can start building the report with the wizard and a limited number of
fields. Then once the report is built by the wizard, you can add the
remaining controls and fields.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Update Fields 0
dynamic adaptive / variable report field format 1
Group last line of details and report footer 0
Filtering subreports on main report 0
Report limits on subreports 3
Select only even or odd number records 4
Character limit on report header? 1
Saving page number from report 5

Top