Welcome to SPN

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

Sign Up Now!

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
     

Share This Page