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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

maximum fields in reports access 2007 2
What is the maximum number of fields allowed in an access report? 2
text box in report is truncating memo field at 255 characters 2
Report Update Fields 0
Filtering subreports on main report 0
Can't create a report from my query in Access 1
Show Maximum Number in Report Footer 1
Font Size 3

Back
Top