Vertical centering on shipping labels (reports) 2

[boxboxbox]

I print off shipping labels based on customer information from a table. I used the report wizard to design the labels, and since customers have varying address--some are three lines, some are international or companies, etc. I could use the "canshrink" property to get them to delete empty space, but I also have a background logo and border, so that doesn't work. I now use a formula in each text box saying things like "if text box 2 = address line 1, then put address line 2" and so on...

Question: Can I get the text boxes (with actual information) to center vertically in the label? For instance, if I put the first line in the middle, then all the lines go below that, sometimes off the label...

Also, if anyone knows a shorter/simpler way of getting the CanShrink property to work even with borders/pictures, or a similar property, I'd be grateful. (Time to get a label maker, methinks)

PS...I really don't understand code and its syntax, so if you answer with that be prepared for more questions.

Thanks!

 

[scriverb]

Try using the Can Grow property for the text boxes that you know may or may not have data in them. By making their vertical height = 0 they will display as a thin line. But, when data is present they will grow to the necessary height to display the data. The Can Grow textBoxes can all be pushed up together as one thin line but in order so that they will display properly when they expand.

Let me know if this works for you.

Bob Scriver

 

[boxboxbox]

Thank you! Trying to figure all that syntax for IfNulls was horrible. Now I'll search for a way to shrink text to fit extra lines at the bottom (if all the address lines are used), or to move it up...(Search is currently down, or I wouldn't even post this)

Anyway--I appreciate your help!

 

[scriverb]

Get back with me if you have any trouble with this. Glad to be of help. Thanks for the Star.

Bob Scriver

 

[boxboxbox]

Aside from a slightly-larger-than-perfect space between the lines of text, this works quite nicely. I still haven't figured out how to shrink text, or move everything up. As of now I can only get four lines on, which doesn't work for international labels...Hints for shrinking or moving? There is another post I found for using FixLine, but I can't get that to work either; methinks it can't find the extra FixLine module.

 

[scriverb]

What do you mean by: Aside from a slightly-larger-than-perfect space between the lines of text


Bob Scriver

 

[boxboxbox]

Basically that the height is set to 0", with the can grow property enabled, and when text shows up there is a space of about 1/4" to 1/3" between the lines. On design view the text boxes are placed on top of each other.

It's an acceptable space between them, but I thought that if that could shrink then there might be more room for more lines.

 

[scriverb]

By setting the Font Size to a smaller size you have less white space if that is what you are concerned about. The Text boxes which look like thin lines can be pushed up one right under the other so they almost look like a single line. Easiest way is to line them up and use the Vertical Spaceing Decerease from the Format menu. Keep doing it until they all move up and disappear into one.



Bob Scriver

 

[boxboxbox]

They are all piled onto each other. I will try shrinking the font size when I have a lot of lines.

Thanks again!