Too many fields in Report?

[everymn]

I have a large test table with 65 fields. This is not an execise in
proper database design, just for test purposes, but when I try to
create a report using the wizard it errors out and says, "the wizard
is unable to create your form or report because you chose too many
fields"

Isn't the limit for fields in a single report considerably larger than
this? Am I just exceeding the capacitiy of the wizard so that I have
to create them manually?
Thank You

 

[Allen Browne]

A report should be able to handle up to 255 fields in its RecordSource, with
up to 700-odd controls.

If you are using the wizard to select the fields to include in the report,
perhaps you could create a query that has all the tables and fields you
need. Then use that query as the souce for the report.

There is another limit, that the total number of actual characters in the
record (excluding BLOBs such as memos, OLE objects, hyperlinks) cannot
exceed around 4000 (or 2000 for older versions of Access.)

 

[Duane Hookom]

You might have exceeded the capacity of the wizard. Personally, I don't use
the wizard since it is fairly easy to create reports manually compared to the
amount of modifications required to wizard created reports.

Your report's record source can contain up to 255 fields and you can have
over 700 controls on a report.