Fields in a report

[jaime]

What is the maximum number of fields allowed a report?


Thanks

 

[Cheryl Fischer]

In Access 2002 you may add a maximum of 754 controls and sections over the
lifetime of the report (or form). To check this out for your version of
Access and to view all of the other database and object specifications,
simply open Help and type "specifications" in the Answer Wizard.

 

[John Spencer (MVP)]

If you don't use a sub-report, then the maximum is 255 fields - based on the
fact that you can have a maximum of 255 fields in a table or a query.

Now, you can get around that limit by using vba to set control values from
recordset and/or the domain functions (DLookup, DMax, etc).