Access 97 Lable Spacing

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

bobbi

Thread Starter
Joined
Dec 21, 2000
Messages
339
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!! :D
 

bobbi

Thread Starter
Joined
Dec 21, 2000
Messages
339
Tried that...didn't work. Still leaves a blank line.

Other ideas?

Thanks
 
Joined
Oct 13, 2000
Messages
941
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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top