HELP! Label nightmare!

[Emma]

I have two columns in a table - box number and object number - and many objects can be in a box. I need to create a label for each box number, listing the box numbers in the box - so it would look like:

Box 1: object 1, object 2, object 3 object4

The size of the labels means that the object numbers need to appear one after the other, separated by a comma ....

Any help would be very, very gratefully received!

 

[bobjames]

Emma
I have a solution for you if you still want it

1. Step up a report base on your table Box/Object table.

2. In the Report create a grouping on the Box field, with group footer set to yes.

3. View the code of the report and type:

Dim BoxContents As String

4. Go back to the detail section and set the visible property of the section to False. In the detail section of the report insert the Field “Object” from your table

5. Go to the On format event of the detail section and insert the code:

BoxContents = BoxContents & " , " & Me!Object

6. In Group Footer section insert the field “Box” from your table then create a text box and name it txtContents

7. Go to the On Format Event for the Group footer and insert the code:

txtContents = BoxContents
BoxContents = ””

hope this helps