Re: Blank Lines in report

From: Tony Williams (tw_at_tcp.invalid)
Date: 03/13/04 

Date: Sat, 13 Mar 2004 18:51:58 +0000 (UTC)

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
> >
> >
>
>