Label Question

R

Regi

Hi,

Some of the adresses for the labels I have to print have a BLDG field and
some don't. I have an expression you see below in so that if there is a
Building # the Word Building comes out before the building #. However, if the
field is null it skips a line on my label. What can I do to fix that?

=IIf(Len([BLDG] &"")=0, "", BUILDING" & [BLDG])

Thanks, Regi
 
K

KARL DEWEY

Set the Can Grow property to Yes and drag the size of the text box to a
hairline.
 
J

Jeff Boyce

Regi

On your report, in design view, set the Can Grow and Can Shrink properties
for the control that "holds" the BLDG info to "Yes".

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
D

Douglas J. Steele

When you say that "it skips a line", do you mean it's printing a blank line,
and you don't want it to print anything?

Use Karl's advise of shrinking the row to a hairline and setting the CanGrow
property to True, but also change

=IIf(Len([BLDG] &"")=0, "", BUILDING" & [BLDG])

to

=IIf(Len([BLDG] &"")=0, Null, "BUILDING " & [BLDG])
 
R

Regi

Thanks!

Jeff Boyce said:
Regi

On your report, in design view, set the Can Grow and Can Shrink properties
for the control that "holds" the BLDG info to "Yes".

Regards

Jeff Boyce
Microsoft Office/Access MVP

Regi said:
Hi,

Some of the adresses for the labels I have to print have a BLDG field and
some don't. I have an expression you see below in so that if there is a
Building # the Word Building comes out before the building #. However, if
the
field is null it skips a line on my label. What can I do to fix that?

=IIf(Len([BLDG] &"")=0, "", BUILDING" & [BLDG])

Thanks, Regi
Click to expand...
Click to expand...
 
R

Regi

Doug,

Yes it was printing a blank line. I wanted it to move the last field up if
there was no Building #. Changing the Can Grow and Can Shrink fields for that
Text Box fixed it. I tried to change the value of "" to NULL in the
expression like you are showing. Nothing changed. It is possible I didn't
write the expression correctly. When I get a chance I think I'll try it
again.
Thanks, Regi


Douglas J. Steele said:
When you say that "it skips a line", do you mean it's printing a blank line,
and you don't want it to print anything?

Use Karl's advise of shrinking the row to a hairline and setting the CanGrow
property to True, but also change

=IIf(Len([BLDG] &"")=0, "", BUILDING" & [BLDG])

to

=IIf(Len([BLDG] &"")=0, Null, "BUILDING " & [BLDG])

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Regi said:
Hi,

Some of the adresses for the labels I have to print have a BLDG field and
some don't. I have an expression you see below in so that if there is a
Building # the Word Building comes out before the building #. However, if
the
field is null it skips a line on my label. What can I do to fix that?

=IIf(Len([BLDG] &"")=0, "", BUILDING" & [BLDG])

Thanks, Regi
Click to expand...
Click to expand...
 
Top