Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can Shrink to remove report white space (Access97 SR-2)

    I have a Main/Sub report with 2 items that are variable, so that under specific conditions, they should not print on the report and I would like the white space (blank lines) to shrink.

    The first is a label in the Detail section of the report. If the report textbox named TradeIn = 0, the label named TradeInParagraph should not print (this part works fine) and the Detail section should shrink to remove white space.

    The second is contained within a subreport in the main report's Detail section. It is located in the subreport's Report Footer. If the subreport's textbox, named TradeIn = 0, the label and textbox, named CustomerTradeInLabel and CustomerTradeIn should not print (this part works fine) and the subreport's Report Footer should shrink to remove the white space.

    Although, the items do not print and there are no other controls on these lines, I cannot get the shrinking part correct. Despite setting the Can Shrink Properties for the main report's Detail section, subreport's Report Footer section and associated controls (except for labels) to Yes, big blank spaces persist.

    Reading about this hasn't helped ... I'm confused about what I can Shrink and what I cannot Shrink. Are there CanShrink Properties for labels? I need help in getting this right. Thank you.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Can Shrink to remove report white space (Access97 SR-2)

    Did you remember to set the CanShrink property for the subreport control on the parent report?
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can Shrink to remove report white space (Access97 SR-2)

    Yes, Charlotte, I did.
    But the textbox labels do not have a CanShrink property, so those are the only items that I could not set.
    What else can I do? As always, I really appreciate your help.

  4. #4
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can Shrink to remove report white space (Access97 SR-2)

    You can use code to set the Labels visible property to false when not needed then the report should shrink OK

    HTH

    Peter

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can Shrink to remove report white space (Access97 SR-2)

    Thank you Bart ... I had done that and they are not visible under the correct conditions. So that part is working, but the main and sub reports will still not shrink!

  6. #6
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can Shrink to remove report white space (Access97 SR-2)

    One other thought then is whether you could set the visible property of the subreport itself to false if it is empty?

  7. #7
    Lounger
    Join Date
    Dec 2000
    Location
    Huntsville AL usa
    Posts
    35
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Can Shrink to remove report white space (Access97 SR-2)

    I believe that labels cannot shrink. That is why you do not find a Shrink property on the labels. Change the labels to TextBoxes, set the source to your label text, and set the Shrink property.

  8. #8
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can Shrink to remove report white space (Access97 SR-2)

    Changing the labels to text boxes on the main report did the trick. Thank you Dan, and everyone else who took the time to offer suggestions. I'm off to try it on the subreport ...

Posting Permissions

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