Results 1 to 5 of 5
  1. #1
    kem is offline Novice
    Windows 7 64bit Access 2000
    Join Date
    Dec 2013
    Location
    Sault Ste. Marie, Michigan
    Posts
    5

    Report breaks into multiple pages when simple changes are made

    I have an Access 2000 database that I've been using successfully for a few years now. I enlarged a text box slightly to allow display of a zip +4 number as opposed to the old ZIP Code. The form then breaks, displaying a single record in pieces over numerous pages.
    I'm dragging the end of the box in design mode, not typing in the changes if that matters. I imagine I'm missing something rather simple, any help would be appreciated.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    The report is probably too wide. While in Design view try positioning the text box that you resized to the left and shrinking the width of the report until the error message in the upper left hand corner of your report disappears.

  3. #3
    kem is offline Novice
    Windows 7 64bit Access 2000
    Join Date
    Dec 2013
    Location
    Sault Ste. Marie, Michigan
    Posts
    5
    I pulled everything closer together and reformatted the page so that my margins were 1/2 inch instead of 1 inch. Now the form fits on one page but there are 3 blank pages between each page with data. Also, the only error message I see is when I switch from design to print preview. It tells me that some of my material is outside of the printable area which doesn't make sense because it takes up less space now than it did. I should warn you, I won't be back until Monday morning so don't feel bad if I don't reply till then.

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    Regardless of the placement of my controls, I get an error if my reports are wider than 8"". I can hover over the little error tringle to learn more about the error. In my reports, the triangle is green.




    .

    Click image for larger version. 

Name:	ReportMarginError.png 
Views:	6 
Size:	11.5 KB 
ID:	14813



    I adjust the width of my reports by using the scale and left clicking the outer left edge of the report and dragging.


    .
    Click image for larger version. 

Name:	RightMargin.png 
Views:	6 
Size:	3.6 KB 
ID:	14814

  5. #5
    kem is offline Novice
    Windows 7 64bit Access 2000
    Join Date
    Dec 2013
    Location
    Sault Ste. Marie, Michigan
    Posts
    5
    Thanks a bunch. I never considered the white space around my data as part of the report. I imagine I can go back to my original report (minus all the interior changes) and just pull in the outer edge.

    As my credits say, I am a novice to the forum. There may be a 2nd reply floating around somewhere as I wrote one left to do something else came back and it was gone. Same information, just longer. Thanks again.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Report Generates Multiple Identical Pages
    By astrolabe262 in forum Reports
    Replies: 1
    Last Post: 02-22-2013, 01:29 PM
  2. Report Sent as HTML Body - multiple pages
    By chris.williams in forum Reports
    Replies: 3
    Last Post: 09-15-2012, 07:18 PM
  3. Replies: 2
    Last Post: 02-08-2012, 01:03 PM
  4. Forced page breaks - I know really something quite simple
    By kw@officeadminsolutions in forum Reports
    Replies: 3
    Last Post: 05-16-2011, 12:17 AM
  5. Blank pages between report pages
    By jonsuns7 in forum Reports
    Replies: 2
    Last Post: 10-01-2009, 05:06 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums