Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    May 2001
    Location
    Monte Sereno, California, USA
    Posts
    137
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Label Line (Access 2000)

    How do you create a conditional line for a Label Report?
    There are occasions when a fourth line is required, such as a %someone.
    I have tried a IIF(IsNull...) as suggested from Help; however, this is producing an input prompt of the non-null field.
    An better solution would be greatly appreciated.
    Ray A.

  2. #2
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Label Line (Access 2000)

    The source table (your address list?) should include a field for this fourth line. Normally it would be blank (null). Include this field on your report. If the value for the fourth line field is null it will just appear as blank. It sounds like this is what you want. You can also set the CanShrink property for this control on your report to Yes which will collapse this line when it's Null. This shouldn't affect the alignment of your labels if your columns and rows are set up correctly in Page Setup (e.g., as set up by the Labels report wizard). Also, as long as the CanShrink property of the Detail section is set to "No" your label height won't vary.

    Hope this helps.

Posting Permissions

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