REPORT

[Gambler]

Im using Access 2000 and windows XP. Im in my report and I get the message TO MANY FIELDS DEFINED. Does this mean I used the maximun number of fields access 2000 allowes. If so, If I purchased a newer version of access would this correct the probem?
Thanks ed

[Rick]

Form and report

Attribute Maximum
Number of characters in a label 2,048
Number of characters in a text box 65,535
Form or report width 22 in. (55.87 cm)
Section height 22 in. (55.87 cm)
Height of all sections plus section headers (in Design view (Design view: A window that
shows the design of these database objects: tables, queries, forms, reports, macros, and
data access pages. In Design view, you can create new database objects and modify the
design of existing ones.)) 200 in. (508 cm)
Number of levels of nested forms or reports 7
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
Number of characters in an SQL statement that serves as the Recordsource or Rowsource
property of a form, report, or control (both .mdb and .adp)

[Rick]

I did a search for Specifications, then clicked on Form and Report. This is in Access 2003.

Try doing that in 2000 and see what you get.

I have no idea if this will do you any good.

Maybe someone knows why you are getting an error.

I can see that they made the SQL statements larger in Access 2002 but I also don't know if that will help you.

I am stilll looking for something related to your error message. I may look at MS next.

[Gambler]

I have over 250 fields in my query. I actually have 277 fields but im not sure when this message started. Ill try and determine the number of fieds required to triggure this message.
Thanks ed

[Rick]

A search of Google groups show a lot of people have reported this error over the years and no one has really come up with a good answer.

Basically they say 255 is the limit. But most of the reports of problems are well under that number.

Common advice is compact and repair database. I don't think that is your answer. Does sound like a lot of fields in you query. You might try elimating those you don't need/use.

[Gambler]

Thanks Rick
ed