maximum fields in reports access 2007

A

Allen Browne

No more than 255 fields can be returned.

And they must all fit in the 4KB page buffer.
(Memos only count the address, not all the text.)
 
M

Marshall Barton

Kim said:
what is the maximum number of fields allow in report wizard in access 2007
Click to expand...


A report's record source table/query can have up to 255
fields.

A report can have up to 754 controls.

The wizards can't handle anywhere near that many of either
object so skip the wizard and just use design view to push
the limits.
 

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

Use a variable in a ShapeRange.Increment 0
What is the maximum number of fields allowed in an access report? 2
Need some PWA help 0
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
What type of inboxes do these icons represent 0
Access 2002 change report header text 0
Open Reports in Maximum Print Preview 8
Show Maximum Number in Report Footer 1

Top