1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Access 97 Lable Spacing

Discussion in 'Business Applications' started by bobbi, Jan 15, 2003.

Thread Status:
Not open for further replies.
Advertisement
  1. bobbi

    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
     
  2. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    No, not trim.

    Try setting the property of the textbox to "Can Shrink"
     
  3. bobbi

    bobbi Thread Starter

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

    Other ideas?

    Thanks
     
  4. downwitchyobadself

    downwitchyobadself

    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.
     
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 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/113365

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice