One handy way to print a variable number of labels is to use an
auxiliary table (which actually comes in handy for several things).
Mine is named Num, with one long integer field N with records entered
for 0 through 10000 or so (more labels than you will ever want to
print).

In the Label report, include the Num table, and don't put ANY join
line. Instead put a criterion on N of

< [How many labels?]

or, if you have a field NLabels in your query indicating the number of
labels for that customer, just

< [NLabels]

For the color, I'm not certain that it works on a Report but take a
look at the "Conditional Formatting" option on the Format menu item.

                 John W. Vinson[MVP]