Blank Lines in report

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

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
 
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?
 
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
 
Have you looked for incomplete information in your query?

--
Duane Hookom
MS Access MVP


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
 
Thanks Duane but the query results look Ok. Any further ideas?
Tony
Have you looked for incomplete information in your query?

--
Duane Hookom
MS Access MVP


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
 
Did you try the other suggestion that I made?

--
Duane Hookom
MS Access MVP


Thanks Duane but the query results look Ok. Any further ideas?
Tony
Have you looked for incomplete information in your query?

--
Duane Hookom
MS Access MVP


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