• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • Last Modified:

First page of 2 page report has messed up format.

I have a report in access that is a 2 page report.  I have attached a pdf file that shows the output for 2 records (4 pages, 2 pages per record).  For some reason the bottom of the first page is out of whack, but the first page of the second record is just fine.  What could be causing this?  How do I fix it? ReportPage1NoPhotos.pdf ReportScreenshotsDesignView.docx
0
phmurphy
Asked:
phmurphy
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
 
  Your first page is too long and it's spilling over onto page 2.  Looks like in the Vegetation section you have the controls set to can shrink or they grew for record one, which has data in these fields.

JimD.
0
 
phmurphyAuthor Commented:
Awesome catch.  I never would have figured that out.  there were numerous text boxes that had Yes for the Can grow property.  I just changed that to no and all good again.
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now