Prev: Different addresses must be accessed depending on time of year.
Next: Sub report based on Crosstab query
From: Kim T on 23 Dec 2009 08:49
what is the maximum number of fields allow in report wizard in access 2007
From: Allen Browne on 23 Dec 2009 09:01
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.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Kim T" <KimT(a)discussions.microsoft.com> wrote in message
news:CDF729A0-34E7-42B5-8FA0-B5D48C4A92F0(a)microsoft.com...
> what is the maximum number of fields allow in report wizard in access 2007

From: Marshall Barton on 23 Dec 2009 09:48
Kim T wrote:

>what is the maximum number of fields allow in report wizard in access 2007


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.

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: Different addresses must be accessed depending on time of year.
Next: Sub report based on Crosstab query