Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Max number of fields

Status
Not open for further replies.

Freckles

Technical User
May 1, 2000
138
US
I have this real disaster of a report to come up with. Everything was going OK until I got "too many fields". What is the limit on the number of fields I can have in an Access 97 report? ::) Deb Koplen
deb.koplen@verizon.com

A person can stand almost anything except a succession of ordinary days.
 
Hello Deb!

This is what I found:

Number of fields or expressions you can sort or group on in a report 10

Number of headers and footers in a report 1 report header/footer; 1 page header/footer; 10 group headers/footers

Number of printed pages in a report 65,536

Number of controls and sections you can add over the lifetime of the form or report 754

I assume that last one is what you are looking for.

Rayna
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top