Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Report columns that Can Shrink

Discussion in 'Information Technology' started by charles.kendricks@charter.net, Jul 28, 2006.

  1. charles.kendricks@charter.net

    Guest

    Is it possible to create columns in a report that can shrink and not be
    visible if the value is null or zero? I also want empty space to be
    evenly distributed among the remaining columns similiar to the way
    subreports can shrink.
     
  2. Loading...

    Similar Threads Forum Date
    UK British Sikh Report-2016 Breaking News Mar 24, 2016
    1984 The Story I Did Not Report In ’84 History of Sikhism Jun 28, 2015
    Opinion Top Green Beret Officer Forced to Resign Over Affair With WaPo Reporter Breaking News Jun 26, 2014
    United Sikhs New Report Shows Increasing Hate Attacks on Sikhs Sikh Organisations May 21, 2014
    Legal ACLU reports: Judge orders Sikh man, "Remove that rag, or Go to Jail! Breaking News Sep 27, 2013

  3. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    <charles.kendricks@charter.net> wrote

    > Is it possible to create columns in a report that can shrink and not be
    > visible if the value is null or zero? I also want empty space to be
    > evenly distributed among the remaining columns similiar to the way
    > subreports can shrink.


    No, CanGrow and CanShrink only apply to the vertical space of Controls, and,
    even then, only if there is no other control alongside. You could, with a
    good deal of work, create your entire line in code and adjust widths on your
    own. To do so, and do it well, would not be a trivial undertaking because
    you'd have to be very well-versed in the metrics of fonts.

    Larry Linson
    Microsoft Access MVP
     
  4. charles.kendricks@charter.net

    Guest

    Thanks, At least now I can stop beating my head against the wall!


    Larry Linson wrote:
    > <charles.kendricks@charter.net> wrote
    >
    > > Is it possible to create columns in a report that can shrink and not be
    > > visible if the value is null or zero? I also want empty space to be
    > > evenly distributed among the remaining columns similiar to the way
    > > subreports can shrink.

    >
    > No, CanGrow and CanShrink only apply to the vertical space of Controls, and,
    > even then, only if there is no other control alongside. You could, with a
    > good deal of work, create your entire line in code and adjust widths on your
    > own. To do so, and do it well, would not be a trivial undertaking because
    > you'd have to be very well-versed in the metrics of fonts.
    >
    > Larry Linson
    > Microsoft Access MVP
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page