Fields in a report

  • Thread starter Thread starter jaime
  • Start date Start date
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.
 
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).
 
Back
Top