if then statements

[deba]

I'm trying to put in an if/then statement for the C/O line of my address
datebase because not all the records have a C/O. This is what I'm entering
in the control source:

=IIf(IsNull([C/O])," ", [C/O])

It still leaves a blank line when I go to print the labels. What am I doing
wrong?

 

[Duane Hookom]

It seems to me that you are ensuring that the control will always take up
space. What happens if you leave the control source as:
[C/O]
and set the control to Can Shrink: Yes?

 

[deba]

Then I get labels that look like this:

John Doe

123 ABC St.
Everywhere, AB 00000

I also do have the control to can shrink set to yes.

Thanks for your help!

It seems to me that you are ensuring that the control will always take up
space. What happens if you leave the control source as:
[C/O]
and set the control to Can Shrink: Yes?

--
Duane Hookom
MS Access MVP
--

I'm trying to put in an if/then statement for the C/O line of my address
datebase because not all the records have a C/O. This is what I'm
entering
in the control source:

=IIf(IsNull([C/O])," ", [C/O])

It still leaves a blank line when I go to print the labels. What am I
doing
wrong?

 

[Duane Hookom]

What is the exact control source of the text box that is set to Can Shrink?
Is it possible the value of the field is either a space or
zero-length-string?

--
Duane Hookom
MS Access MVP
--

Then I get labels that look like this:

John Doe

123 ABC St.
Everywhere, AB 00000

I also do have the control to can shrink set to yes.

Thanks for your help!

It seems to me that you are ensuring that the control will always take up
space. What happens if you leave the control source as:
[C/O]
and set the control to Can Shrink: Yes?

--
Duane Hookom
MS Access MVP
--

I'm trying to put in an if/then statement for the C/O line of my
address
datebase because not all the records have a C/O. This is what I'm
entering
in the control source:

=IIf(IsNull([C/O])," ", [C/O])

It still leaves a blank line when I go to print the labels. What am I
doing
wrong?

 

[KARL DEWEY]

You are telling to have a blank by using " " in your syntax. Omit the space
between quotation marks.

 

[tina]

I also do have the control to can shrink set to yes.

try also setting the report's Detail section's CanShrink property to Yes.

hth