Printing labels on a template with only 1 column

[bigalpha]

I currently have a set of labels that works flawlessly - it has 2 columns and 20 rows. I have a form that I can select which label to start printing on so I use up a full sheet with no waste. [working labels attachment]

The labels I'm trying to print on now are 1.25" x 10", as seen HERE. Since I cannot rotate the whole report 90 degrees, I set up the labels to have one column with six rows instead of 6 columns with one row (landscape instead of portrait).

I copied the entire label printing process from the known working report. For my new set of labels, the label prints great if I have just one record, and/or I start at label #1. If I want to start at label #6, it just prints slightly lower on the page instead of at label #6 position (which is the bottom of the page). [label at #6 position attachment].

Is there some work around, or something basic I'm missing that can accomplish my goal?

TIA

 

[bigalpha]

Doo dee doo. Anyone?

 

[David R]

Is your label Detail set up for Can Shrink? (it shouldn't be)

Sounds like the five blank ones are collapsing...

 

[CJ_London]

May not be quite what you want and no doubt will require some additional coding but have you considered the following:

1. Go back to print in portrait mode
2. For your report design have 6 subforms sized per your labels side by side
the subform contains the contents of your label - set the text orientation to vertical. - you'll find it under the other property tab

Note you only have 1 actual subform form but it is on the main form 6 times - hope that make sense

3. Somewhere on your main report have 6 textbox controls (suggest at the top of each subform) which will act as the linkmasterfield for each subform - you can set their visible property to false or position them so they print outside the label. The linkchildfield will be the same for each subform - presumably and ID of some sort

4. Finally you just need some code to populate the 6 textboxes with the appropriate ID to populate the subforms.

Note that vertical only reads one way - top to bottom - which is a real pain since the more 'natural way' is bottom to top. The vertical property is only available for text boxes - not list/combo etc

 

[bigalpha]

Is your label Detail set up for Can Shrink? (it shouldn't be)

Sounds like the five blank ones are collapsing...

I set the 'can shrink' property to NO for all parts of my report and it didn't change the output.

 

[bigalpha]

May not be quite what you want and no doubt will require some additional coding but have you considered the following

I have not considered that - my coding skills are fairly weak.

Also, I attached a copy of the relevant part of the label making process. It starts with form frmManifestFolderLabels. It might be easier to see what I'm talking about?