Solved Print labels starting in specific location.

[LALovelady]

The rptLabels report starts printing in upper left corner. I'd love to be able to decide what position to start my label so I can use a label sheet that has been partially used.

 

[June7]

Options I can think of:

1. write data to a temp table and add enough blank rows to account for the used label spaces. Anything else will require even more complicated VBA

2. have a table of 'blank' records and UNION it to the data table

 

[CJ_London]

it can be done but quite frankly the cost of modifying the system, a user working out where the labels are required to start (don't think you can rely on wherever they finished last time) and perhaps getting it wrong etc versus the cost of a partial sheet of labels - is it worth it? And if you are only printing one or two labels at a time, perhaps you have the wrong type of printer?

 

[arnelgp]

see your Report

 

[LALovelady]

see your Report

You are amazing!! Thanks for your help!!