Label Question

[Guest]

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

 

[Guest]

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

 

[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

 

[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])

 

[Guest]

Thanks!

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

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

 

[Guest]

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

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!)

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