Link to home
Create AccountLog in
Avatar of spazjr01
spazjr01Flag for United States of America

asked on

Can't change Detail height property of Access Report.

I created a report to print a directory from my address table/query.  I want the records to be listed one after another without much space in between.  As you can see in the attached screenshot, there are over 2 inches of extra space between the last displayed object and the end of the Detail section.  But, I can't close that space.  I've tried to drag the section's bottom handle up, but it always goes back to the displayed setting.  I tried to change the 4.6563" Height property in the Property window.  But, the number always reverts to 4.6563".  How do I change this?  Is there some other setting or object that is possible preventing me from editing this.
Report-Design-Screenshot.docx
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

there must be something in the detail section that is preventing you to resize the height..

try this,
place your mouse on the left ruler just below the 2 inch marker and drag it just above the Page Footer, then press delete
now try to adjust the height


* better if you can upload a copy of the db
ASKER CERTIFIED SOLUTION
Avatar of spazjr01
spazjr01
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of spazjr01

ASKER

My comment contains the actual solution.