vertical compression?

[Laurel]

How do I get my label fields to compress vertically. That is, if there's
nothing in Address2, how do I get the city-state-zip data to slide up. The
maddening thing is that I've done it already. But I've looked and looked
and looked at my labels that do this and I can't find where the setting is.

tia
las

 

[Marshall Barton]

How do I get my label fields to compress vertically. That is, if there's
nothing in Address2, how do I get the city-state-zip data to slide up. The
maddening thing is that I've done it already. But I've looked and looked
and looked at my labels that do this and I can't find where the setting is.

It's the CanShrink property.

Are you using a separate text box for each part of the
address or do you have it all in one text box?

 

[Laurel]

Thanks. I had tried that, and it wasn't working (it is, indeed, set on the
labels that do work). But given your response I played around some more and
discovered that "can shrink" doesn't work if there is another item off to
the right of the "can shrink" item. My report wasn't really labels, there
were lots of things besides a name and address on it.

I have all of my address pieces in separate text boxes. I assume there's no
fix for my remaining little problem other than moving items out of the space
to the right of the one I want to shrink?

 

[fredg]

How do I get my label fields to compress vertically. That is, if there's
nothing in Address2, how do I get the city-state-zip data to slide up. The
maddening thing is that I've done it already. But I've looked and looked
and looked at my labels that do this and I can't find where the setting is.

tia
las

So you have the Name, Address1, Address2 and City, State Zipcode, and
you sometimes don't have an [Address2]. Correct?

Add an unbound control under [Address1].
Set it's control source to:
=IIf(Not IsNull([Address2]),[Address2] & chr(13) & chr(10) & [City] &
", " & [State] & " " & [ZipCode], [City] & ", " & [State] & " " &
[ZipCode])

It will display Address2 and City/State/Zip or just City/State/Zip.

 

[Marshall Barton]

Bad assumption ;-)

The solution is to use one can shrimk text box.

You can use the kind of thing in Fred's reply or a slightly
shorted but trickier expression along these lines:

=addr1 & (Chr(13) + Chr(10) + addr2) & Chr(13) & Chr(10) &
city &", " & state & " " & zip

 

[Laurel]

Thanks to all. I'm all set in a couple of ways.

Bad assumption ;-)

The solution is to use one can shrimk text box.

You can use the kind of thing in Fred's reply or a slightly
shorted but trickier expression along these lines:

=addr1 & (Chr(13) + Chr(10) + addr2) & Chr(13) & Chr(10) &
city &", " & state & " " & zip
--
Marsh
MVP [MS Access]

Thanks. I had tried that, and it wasn't working (it is, indeed, set on
the
labels that do work). But given your response I played around some more
and
discovered that "can shrink" doesn't work if there is another item off to
the right of the "can shrink" item. My report wasn't really labels, there
were lots of things besides a name and address on it.

I have all of my address pieces in separate text boxes. I assume there's
no
fix for my remaining little problem other than moving items out of the
space
to the right of the one I want to shrink?

"Marshall Barton"wrote .