A Allen Browne Dec 23, 2009 #2 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.)
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 Dec 23, 2009 #3 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.
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.
