format labels

[Guest]

When I have blank cells and I create labels, it leaves a blank space. How do
I fix this? I have the can shrink option on. Thanks!

 

[Guest]

Try turning on the Can Grow and reducing the object size to a hairline.

 

[Guest]

It doesn't work. Here is a more detailed synopsis of the problem. I am
creating address labels and I have a column titled "C/O" Each record doesn't
have a C/O, so when it is blank, it leaves a blank row on the label print
out. Does that make sense? Thanks for your help.

 

[Guest]

Did you reduce the size of "C/O" and the object directly to the right also?

 

[Guest]

If I reduce the size of the C/O font then it will decrease the cells that
actually have something in the cell to be smaller and I don't want it to do
that. If it doesn't have anything in the C/O cell, I want it to go onto the
address line. So I want it to look like:

John Doe
123 ABC Street
Anywhere, USA

instead of...

John Doe

123 ABC Street
Anywhere, USA

thanks for your help!

 

[Guest]

See my answers in Access.TableDesign

If I reduce the size of the C/O font then it will decrease the cells that
actually have something in the cell to be smaller and I don't want it to do
that. If it doesn't have anything in the C/O cell, I want it to go onto the
address line. So I want it to look like:

John Doe
123 ABC Street
Anywhere, USA

instead of...

John Doe

123 ABC Street
Anywhere, USA

thanks for your help!

 

[UpRider]

Deba, I think Karl means to reduce the size of the text box itself for that
line and set it to can grow, not reduce the font size.

HTH, UpRider

 

[Gina Whipp]

What about placing the below in the text box for c/o:

=IIf IsNull([c/o field neame]), Null, [c/o field name])

Set the field to can shrink.