D
deba
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!
I fix this? I have the can shrink option on. Thanks!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
KARL DEWEY
Try turning on the Can Grow and reducing the object size to a hairline.
D
deba
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.
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.
K
KARL DEWEY
Did you reduce the size of "C/O" and the object directly to the right also?
D
deba
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!
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!
K
KARL DEWEY
See my answers in Access.TableDesign
deba said: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!
U
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
line and set it to can grow, not reduce the font size.
HTH, UpRider
G
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.
=IIf IsNull([c/o field neame]), Null, [c/o field name])
Set the field to can shrink.