Labels (Access 2007)

Topic

New Reply

Can you help a newb please. Virtually my first time using 2007.

I’m trying to create labels for my Mini-DV tapes. I have had to create a custom label 4.5cm high. and 6.5 cm wide.

My labels however do not output correctly. See attached image showing layout and print preview. The colums are set up (apparently correctly) on page set-up,

It seems as if I need to force a new label at the right height, rather like a page break, but I can’t see how. If I make the detail a total of 4.5 cm high, then I get the right label size, but only 1 clip list per label.

Do I need some form of sub-report?

I’m sure you’ll need extra info, but not sure what to include.

Any help welcome

Thanks

Colin

Reply | Quote

Replies

I think you’ll need to create a subreport to list the clips. The subreport would go into the group header, and the detail section of the main report would have height 0.

Or you could use the Concat function from post 301,393, but I think that’d be more work.

Reply | Quote

Wow that’s fast!!!!!!!!!!!!!!!!!!!!!!!!!!!

I’ll have a look at the sub report.

Thanks

Colin

Reply | Quote

Thanks Hans. Worked perfectly.

I’ve spent 2 hours trying to solve this. I do like to try and solve my own probs as it’s the best way to learn, but!!!

I had tried a sub report, but put it in the detail. Never thought it should go in the Header.

Thanks again, and particularly for such a fast response.

Colin

Reply | Quote