I have generated a report in access 2000 vba using all labels for data and backcolors.
Rational for this: Individual fields and the complete row may have different back colors. ie... bottom color label layer visible, normal, whole row; next color label, visible or not,transparent, for individual data field; label for data transparent and visible.
Data is entered via do until loops analyzed for color control and posted to report.
Without the input box to control the loops what is printed is the end of the loop.
For one or two items this is ok but for several hundred this is not a good solution.