Welcome to SPN

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

Sign Up Now!

Report Question

Discussion in 'Information Technology' started by Dee, Jul 28, 2006.

  1. Dee

    Dee
    Expand Collapse
    Guest

    I am creating a report and I find that one of the fields wraps on to another
    line. I have another field underneath this field so if the first field
    doesn't wrap to two lines there is too much space between my first field and
    the second. For example the first field is Site Name, which sometimes the
    name of the site is very long and wraps to the next line. The field
    underneath is the Country field. So I get a lot of space between the site an
    the country if the site name doesn't wrap to a second line. Is there a way to
    tell Access to delete the extra line space if the field does not wrap. I am
    using Access 2003.

    Thanks very much for any help.
     
  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. Rick Wannall

    Rick Wannall
    Expand Collapse
    Guest

    YOu can probably solve this by reducing the height of all controls
    (including the one with the data that wraps) so that they are one line high.
    Then set your detail section and all controls to CanGrow=true. If you place
    the control on the second line immediately below the control on the first
    line, everything works out. IF the data doesn't wrap, the second control is
    right below the one-line-high control. If the data does wrap, the detail
    section expand to accommodate the control holding the wrapped data, and the
    second control is STILL just below the expanded control on line 1.
     
  4. Dee

    Dee
    Expand Collapse
    Guest

    Dear Rick,

    That worked out perfectly. Thank you so much for your help.

    "Rick Wannall" wrote:

    > YOu can probably solve this by reducing the height of all controls
    > (including the one with the data that wraps) so that they are one line high.
    > Then set your detail section and all controls to CanGrow=true. If you place
    > the control on the second line immediately below the control on the first
    > line, everything works out. IF the data doesn't wrap, the second control is
    > right below the one-line-high control. If the data does wrap, the detail
    > section expand to accommodate the control holding the wrapped data, and the
    > second control is STILL just below the expanded control on line 1.
    >
    >
    >
     

Share This Page