Although you can create labels using the Label Wizard, those labels print each field on its own line, starting at the left edge of a label. If you want more flexibility in labels, such as several fields on one line or fields that appear in the upper-right corner of the label, use the Advanced Report Designer. Here's how you do it.

1. Create a Quick Report.

2. In Step 2 of the Quick Report Wizard, select the fields you want to appear in the labels.

   

3. In Step 5, turn on the Advanced layout setting and click the Edit button to bring up the Advanced Report Designer. Choose Yes when asked if you want the objects in the report auto-fitted for width.

4. Click the gray bar with "Detail" in it and drag it down so the Detail band is the height of your labels (the ruler at the left edge of the Advanced Report Designer shows the height). Alternatively, you can double-click the Detail bar and in the dialog that appears, enter the label height for the height of the band.

5. Move the fields in the Detail band so they are laid out as you expect to see them in each label.

6. Select all the objects in the Page Header, Page Footer, and Summary bands (the fast way to do this is to hold down the Shift key and double-click the gray bar for the band) and press Delete to delete them. Resize the Page Footer and Summary bands so they are 0" high. Size the Page Header band so it's the distance from the top of the page to the first label (measure that with a ruler).

   

7. From the File menu, choose Page Setup. In the Page Layout page of the Report Properties dialog, click the Page Setup button, choose Portrait, and click OK. Change the Number setting under Columns to the number of labels across each page. Set Spacing to the amount of space between labels (you likely need to measure that with a ruler). Set Left margin to the amount of space between the left edge of the page and the start of the first label (measure that as well). Select the Left to right button under the Column print order setting so labels print left-to-right rather than top-to-bottom. Click the OK button.

   

8. Adjust the width of any field that extends beyond the right edge of the label.

   

9. Select all of the fields and double-click the first one. In the Properties page of the Multiple Selection dialog, turn on the Apply these conditions to the selected objects upon saving option and then turn on the Remove line if blank setting. Click OK to close the dialog.

   

10. From the Report menu, choose Print Preview to ensure the labels look the way you expect them. If not, make any adjustments necessary.

    

11. Close the Advanced Report Designer to save your changes, then click the Finish button to save the label.

12. To test that the labels correctly print on your label stock, create a filter in the Filter page of the Reports Explorer that prints only enough records for two pages of labels (you can click Preview after setting the filter to see how many pages are used, and adjust the filter accordingly until the desired number appears). Load the labels into your printer and click the Print button to print the labels. Ensure the records print properly on each label, especially at the top of the second page. If necessary, click the Edit button and used the Advanced Report Designer to adjust the layout as necessary. Repeat until the labels print correctly.