Labels leaving a blank line where addr2 is missing

[Brenda Lichius]

Some of my addresses have 1 address line and some have 2. In order to include
all of them in the same label, I'm getting a blank line when address 2 is
missing. Why won't it float if there is a blank line?

 

[Evi]

First, check that the Section that contains your Address fields is set to
Grow and Shrink. To do this, click inside that section or on the grey bar
just above it but ensure that you are not selecting any controls. In the
Properties box next to Can Grow and Can Shrink (like Alice In Wonderland)
click Yes.
2. Click in the left margin so that you are selecting all your text boxes
(not the labels though) and set them to Grow and Shrink too.

See if that does the trick.

Finally, if you have any labels (as opposed to text boxes), these do not
Grow and Shrink but you can get rid of them (by replacing your fields with a
Text Box which says eg .

="Address:" & [NameOfYourAddressField]
Delete all your labels and see if this does it.

Evi

 

[Brenda Lichius]

I changed the property of the detail to CanShrink and of the text box which
contains the address 1 and the one which contains the address 2 fields but
I'm still getting a blank line.
--
Brenda

First, check that the Section that contains your Address fields is set to
Grow and Shrink. To do this, click inside that section or on the grey bar
just above it but ensure that you are not selecting any controls. In the
Properties box next to Can Grow and Can Shrink (like Alice In Wonderland)
click Yes.
2. Click in the left margin so that you are selecting all your text boxes
(not the labels though) and set them to Grow and Shrink too.

See if that does the trick.

Finally, if you have any labels (as opposed to text boxes), these do not
Grow and Shrink but you can get rid of them (by replacing your fields with a
Text Box which says eg .

="Address:" & [NameOfYourAddressField]
Delete all your labels and see if this does it.

Evi

Some of my addresses have 1 address line and some have 2. In order to include
all of them in the same label, I'm getting a blank line when address 2 is
missing. Why won't it float if there is a blank line?

 

[Marshall Barton]

Some of my addresses have 1 address line and some have 2. In order to include
all of them in the same label, I'm getting a blank line when address 2 is
missing. Why won't it float if there is a blank line?

Did you use the CanShrink property?

 

[Larry Linson]

I changed the property of the detail to CanShrink and of the text box which
contains the address 1 and the one which contains the address 2 fields but
I'm still getting a blank line.

Is there any other Control on that line besides the Address2 Text Box? Is
the Address2 Text Box touching any other Control? Either can defeat the Can
Shrink.

For Labels you want the Control to be Can Shrink, but you probably do not
want the Detail to Grow or Shrink, as it may throw the following labels
off-position.

Larry Linson
Microsoft Office Access MVP