Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can Shrink on Report (Access 97, sr2)

    I figured out a way to HIDE fields if they do not meet a certain criteria on a report and I have used the can shrink figure to squeeze everything together, however, I still have some big gaps in the report. Is there anyway to remove all the "spaces"?

    The reason for the HIDING is that I could not filter the data because I created a calculated field on the report and if the person was noted as "COMPLETED", I did an event and hid the fields so the information would not appear. I made a simple report sorta complicated but it works except for the extra white spaces.

    Thanks,
    Deborah

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can Shrink on Report (Access 97, sr2)

    Have you set the can shrink property of the detail section (if this happens in the detail section) to Yes ?
    Francois

Posting Permissions

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