Report Label Query

[GJT]

I have a requirement to create a labelling facility in my database. On the old DB - an AVERY label sheet is manually fed into the printer and we are able to print off exactly the right number of labels by entering the start / end positions on the sheet (working from left to right) 3 columns / 7 rows....... so if only 3 labels are required, 18 labels are left unused on the sheet. This can be fed back into the printer at a later date and the report re-run from a new start position i.e. start position = 3 / end position = 21, to use the remaining labels on the form.

The source table for this report only contains one record and the report generates 'n' instances of this label on the sheet. (where n is a user parameter)

I would like to do the same in my Access database - has anyone done anything similar or know of some code I can use to implement this functionality please ?

Thank you.

 

[GJT]

Thanks Pat - your a life saver!

 

[GJT]

Dear Pat / All

Further to my last posting - I seem to have found a bug in the code available from MS for priting multiple labels on a sheet.

When the code is run (skip 3 labels and print 2 copies) - the report displays in Print Preview mode as expected, however when printed the sheet shows 2 copies printed from the top l/h corner of the page?

Also, when in Access' Print Preview mode for the report (display is correct), if select Page Setup and then OK button, display shifts from formatted display to formatting from top left (as earlier)!

Do you have any ideas what could be happening between the preview and setup / printing of this label format?

Regards

GJT