Help with strategy

I'm trying to create simple labels using Access 2003 but can't get the formatting correct, so I think I have to write code to get around it.

I have a database of video tapes. I want to create labels (spine/face) for each tape. The problem is that some tapes have multiple videos recorded on them. When I create a label report in Access and group by tape number, the size of the label changes depending on how many videos are on each tape. This won't work, obviously. So, I think I have to loop through the selected videos and create a field that contains all videos on each tape.

Is this the correct strategy? I'm sure there are many ways to accomplish the same thing, but (of course) I'm looking for the easiest!!

Thanks for any help you can offer!

You might be able to use some vba code to adjust the font size on the label. I think there are some properties that will let you inspect the proposed size of the field in code, if it's too big you could shrink the font size and try again.

Just guessing here, there is probably some easier way to do this.