Re: Blank Lines in report

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 03/13/04 

Date: Sat, 13 Mar 2004 16:57:54 -0600

Have you looked for incomplete information in your query? 

-- 
Duane Hookom
MS Access MVP
  "Tony Williams" <tw@tcp.invalid> wrote in message news:c2vl8d$e0h$1@sparta.btinternet.com...
  This is how it looks Duane
  Distributed to Group/List
    Accountancy Panel
    Asset Finance Fraud Forum
    MFD Management Committee
    Money Laundering Working Party
    2003.00005  09/09/2003  Diane Williams
    UV Lamps
    D:\Documents and Settings\Administrator\Tonys Work\Excel Spreadsheets\VFU Lamps\UVLamps.xls
    Distributed to Group/List
    Asset Finance Fraud Forum
    Data Protection Working Party
    MFD Management Committee
    2003.00006  09/09/2003  Edward Simpson
    Response to DTI on CCA Regulations
    Distributed to Group/List
    Credit Sub Committee
    Legal Sub Committee
    2003.00007  20/09/2003 Ashley Holmes
    New APR Formulas
    Distributed to Group/List
    Accountancy Panel
    Business Code of Practice Group
    2003.00008  23/09/2003 Dennis Jeffrey
    Settlement regulations
    Distributed to Group/List
    Business Code of Practice 
  The header finishes after "Distributed to Group List"
  Look at the different spacing before the detail starts it looks like an extra line space?
  Any Ideas?
  Tony
  "Duane Hookom" <duanehookom@NO_SPAMhotmail.com> wrote in message news:e39OfWSCEHA.2560@TK2MSFTNGP12.phx.gbl...
  > This is not a normal situation. Are you suggesting that if the header was
  > department and the detail was a person, your report might look like:
  > 
  >    Human Relations
  >         Cole
  >         Christine
  >         Cindy
  >         Kristy
  >     IT
  >         Brian
  >         Glenn
  >         Polly
  > 
  >     Finance
  >         Cathy
  >         Kelly
  > 
  >     Engineering
  > 
  > etc with a constant number of blank spaces? Have you tried changing the
  > background colors of your sections so you can determine where the extra
  > space is coming from?
  > 
  > -- 
  > Duane Hookom
  > MS Access MVP
  > 
  > 
  > "Tony Williams" <tw@tcp.invalid> wrote in message
  > news:c2vgb8$dif$1@titan.btinternet.com...
  > > I have a report that has a header for one control and the detail showing
  > > another control. There is a one to many relationship between the header
  > > control and the detail control. when I run my report the detail seems to
  > > take the space of the record with the most number of lines.eg if one
  > header
  > > has 4 detail lines then all the header's details section seem to have
  > those
  > > many lines but may only show 1,2 or 3 records as the case may be. Is there
  > > anyway I can make the detail  take up only the space it needs? I've
  > changed
  > > the control property to can shrink but that doesn't seem to help.
  > > TIA
  > > Tony Williams
  > >
  > >
  > 
  >
Loading