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) |
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) |
32,750 |