Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    May 2001
    Location
    MIA (takittodahous), Florida, USA
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hiding Report Fields (2000)

    Hi all,

    I'm getting back in to Access again after a 2 (well almost) year hiatus from it. I'm trying to get fields that don't have data to hide. I'm trying to avoid macros but if I gotta, I gotta.

    Thanks in advance for the he'p.

    -Bill

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

    Re: Hiding Report Fields (2000)

    There are numerous ways to accomplish this depending upon what you mean by "fields that don't have data " and where they are positioned on the report. Try changing the Can Shrink Property for that textbox to Yes. If that doesn't do what you need, post back with more detail.

  3. #3
    Star Lounger
    Join Date
    May 2001
    Location
    MIA (takittodahous), Florida, USA
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding Report Fields (2000)

    I've got those attributes set to Yes - but it doesn't collapse the fields like I was hoping. Basically, I'm pulling address info for 6 fields I have 'stacked' in the report - if there is no info in a field, I'd like it to collapse and let subsequent fields with data butt up against the previous filled field.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hiding Report Fields (2000)

    You also need to set the CanShrink property of the section to Yes. Setting it for the text boxes only is not enough.

    You can't use labels with the text boxes - they won't shrink.

    You also must avoid having other types of controls in the same horizontal position as the text boxes - lines, combo boxes, frames etc. won't shrink either.

    Finally, make sure the text boxes don't overlap - that may cause problems.

Posting Permissions

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