Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Fields don't shrink (2002)

    Hi,

    I have report that contains 11 columns that are visible or not visible based on criteria on open. This is working fine (thanks to Hans!). I've set the property of each field to yes re can shrink, including on the labels (which are also visible or not visible based on open criteria). My problem is that they are not shrinking when not visible and the remain in the same location. Is there anything else I should be doing or is this even possible with columns in a report. Also, I noted that the there doesn't seem to be a property setting to shrink for labels, or at least I didn't see one.

    Thanks,
    Leesha

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

    Re: Fields don't shrink (2002)

    As you noticed, labels don't have a Can Shrink property. You will have to omit labels if you want to benefit from the Can Shrink property of text boxes, or write code to hide the labels if necessary.

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Fields don't shrink (2002)

    At the risk of sounding really dumb, is "hiding" the labels the same as making visibility = false? I made them visibile in code based on the form criteria. That part is working fine.

    Thanks,
    Leesha

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

    Re: Fields don't shrink (2002)

    Yes, hiding a control is the same as setting .Visible = False.

    Hmm, you wrote that you hide certain columns. Setting Can Shrink to Yes only moves controls UP, never to the LEFT. If you want to move entire columns to the left, you'll have to write more complicated code.

  5. #5
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Fields don't shrink (2002)

    Thanks Hans for the info. I think I'll leave it the way it is as "writing more complicated code" is not my strong suit as you well know!

    Leesha

Posting Permissions

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