Access - Reports

[kip]

In designing a report, what commands will close a line if
no data is shown in the field?

i.e.

=[pobox]
=[street]

If the pobox does not contain data, how do I get the
report to close the pobox line rather than having a blank
line print on the report?

THX,

Kip

 

[Duane Hookom]

Look at the Can Shrink property.

 

[Kip]

Thx for your speedy reply.

Here's my problem. I do have Can Shrink set to yes.

My statement is
=Iif(IsNull[street]," ",[street])
What I am trying to accomplish is to have no blank line
print if there is no data in my [street] field. w\What is
happening is if there is no data, it is printing a blank
line, not closing the space.

Any other ideas?

Thx,

Kip
When

-----Original Message-----
Look at the Can Shrink property.

--
Duane Hookom
MS Access MVP

In designing a report, what commands will close a line if
no data is shown in the field?

i.e.

=[pobox]
=[street]

If the pobox does not contain data, how do I get the
report to close the pobox line rather than having a blank
line print on the report?

THX,

Kip

.

 

[Duane Hookom]

It makes no sense to display a space. Is there a reason why you don't have
the control source set to:
[Street]

--
Duane Hookom
MS Access MVP

Thx for your speedy reply.

Here's my problem. I do have Can Shrink set to yes.

My statement is
=Iif(IsNull[street]," ",[street])
What I am trying to accomplish is to have no blank line
print if there is no data in my [street] field. w\What is
happening is if there is no data, it is printing a blank
line, not closing the space.

Any other ideas?

Thx,

Kip
When

-----Original Message-----
Look at the Can Shrink property.

--
Duane Hookom
MS Access MVP

In designing a report, what commands will close a line if
no data is shown in the field?

i.e.

=[pobox]
=[street]

If the pobox does not contain data, how do I get the
report to close the pobox line rather than having a blank
line print on the report?

THX,

Kip

.

 

[Guest]

How would you write the line to print the street if
[street] has a value and to not print a blank line when
there is no value in [street]?

Thx again,
Kip

-----Original Message-----
It makes no sense to display a space. Is there a reason why you don't have
the control source set to:
[Street]

--
Duane Hookom
MS Access MVP

Thx for your speedy reply.

Here's my problem. I do have Can Shrink set to yes.

My statement is
=Iif(IsNull[street]," ",[street])
What I am trying to accomplish is to have no blank line
print if there is no data in my [street] field. w\What is
happening is if there is no data, it is printing a blank
line, not closing the space.

Any other ideas?

Thx,

Kip
When

-----Original Message-----
Look at the Can Shrink property.

--
Duane Hookom
MS Access MVP


In designing a report, what commands will close a

line
if

no data is shown in the field?

i.e.

=[pobox]
=[street]

If the pobox does not contain data, how do I get the
report to close the pobox line rather than having a blank
line print on the report?

THX,

Kip


.

.

 

[Duane Hookom]

Set the control source to
[Street]
and the Can Shrink property to Yes.
Keep in mind that if other controls are to the left or right of this
control, the can shrink doesn't do any good.

--
Duane Hookom
MS Access MVP

How would you write the line to print the street if
[street] has a value and to not print a blank line when
there is no value in [street]?

Thx again,
Kip

-----Original Message-----
It makes no sense to display a space. Is there a reason why you don't have
the control source set to:
[Street]

--
Duane Hookom
MS Access MVP

Thx for your speedy reply.

Here's my problem. I do have Can Shrink set to yes.

My statement is
=Iif(IsNull[street]," ",[street])
What I am trying to accomplish is to have no blank line
print if there is no data in my [street] field. w\What is
happening is if there is no data, it is printing a blank
line, not closing the space.

Any other ideas?

Thx,

Kip
When
-----Original Message-----
Look at the Can Shrink property.

--
Duane Hookom
MS Access MVP


In designing a report, what commands will close a line
if
no data is shown in the field?

i.e.

=[pobox]
=[street]

If the pobox does not contain data, how do I get the
report to close the pobox line rather than having a
blank
line print on the report?

THX,

Kip


.

.

 

[Larry Linson]

Set the control source to [Street]
and the Can Shrink property to Yes.
Keep in mind that if other controls
are to the left or right of this control,
the can shrink doesn't do any good.

A workaround, admittedly not "elegant", might be to put the address
information in a Form embedded in a small Subform Control... the Subform
Control itself can't Shrink if there are adjacent Controls, but at least
there won't be a blank line in the middle of the address itself.

Larry Linson
Microsoft Access MVP