Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2001
    Posts
    175

    Question Unanswered: shrinking fields on a report

    I have a report that displays the following:

    name
    address1
    address2 Invoice No.
    city Date
    country

    The CanShrink property for all fields with the exception of name and address1 has been set to 'yes'. However not every record has an 'address2' but instead of moving 'city' up, it gives a blank space.

    How can I get 'city' to move up???? I have many reports with this problem and don't know how to fix it. Is it because I have fields on the right-hand side of the report (which I can't remove)?

    HELP!!!!!!!

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Try the following:

    = Trim[Address1] & IIf(Len(Trim([Address2]))>0,"
    " & [Address2],"")

    The "" has a ctrl-enter between the quotes.

    Good luck.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •