Access 97 Lable Spacing

[bobbi]

Hi

I just know there is any EASY answer to this...but I can't find it.

In Access 97 I have a report that prints form letters. Each address is printed at the top. I have an address and POBox field. Each record does not have a POBox, so in some of the letters there is a blank space. How do I get the space to close up if there is not information in it?

The TRIM feature does not work in 97.

Thanks!!

 

[Anne Troy]

No, not trim.

Try setting the property of the textbox to "Can Shrink"

 

[bobbi]

Tried that...didn't work. Still leaves a blank line.

Other ideas?

Thanks

 

[downwitchyobadself]

The Can Shrink property will only work if:

1. the text box in question has a value of null (empty) - so make sure the underlying field does not allow empty strings (check the field properties in table design). To be doubly sure, you can always change the name of the control and its control source to:

MyFieldDisplay
=Iif(Len(Cstr([MyField]))>0;[MyField];Null)

2. there are no other controls on the same line.

Under those conditions, there is no reason that the line should not disappear.