Unusual request. Of course, there is no way to know if all the jobs will fit
on a label, but you could do it with a subreport, or a function.
The subreport would appear on this report, and you set its Link Master
Fields and Link Child Fields properties to [Part #] so it shows the jobs for
the part. The subreport's Can Grow property will default to Yes, but make
sure your Detail section's Can Grow and Can Shrink are set to No so that the
report still matches the fixed-height label.
Alternatively, if you want the job numbers listed horizontally instead of
vertically, use the code from this function in the Control Source of a text
Return a concatenated list of sub-record values
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://www.yqcomputer.com/
Reply to group, rather than allenbrowne at mvps dot org.