Page 1 of 2 12 LastLast
Results 1 to 15 of 21
  1. #1
    pharrison74 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2016
    Posts
    114

    Large Gap between entries

    Hi all I have attached a image. I have created a report and for some reseason all my reports have a large gap between each entry. How can I fix this?



    Thanks
    Click image for larger version. 

Name:	Capture.JPG 
Views:	15 
Size:	186.2 KB 
ID:	23569

  2. #2
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Go to report design view and shrink the spaces as needed. The space you identified in yellow is likely between the report footer and detail section. If you need more help, perhaps post an image of the report in design view instead.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    pharrison74 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2016
    Posts
    114
    Thanks for the reply. There is little to no space there. However here is a snapshot.

    Click image for larger version. 

Name:	Capture_2.JPG 
Views:	15 
Size:	85.3 KB 
ID:	23570

  4. #4
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Now I think your OP image is of a layout view, not a report view or print preview. Do you have this same issue in either of those views, and if so, do you have the background control set to 'Can Grow'?

  5. #5
    pharrison74 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2016
    Posts
    114
    Yes it does the same thing in print and report view. When I print it actually forces the data to the next page. I do have it set to can grow as when I change it to know all the data doesn't show.
    Thanks
    Pete


    Quote Originally Posted by Micron View Post
    Now I think your OP image is of a layout view, not a report view or print preview. Do you have this same issue in either of those views, and if so, do you have the background control set to 'Can Grow'?

  6. #6
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Then look at the property sheet format tab and see if you have Force New Page is 'None' or one of the other options. I suspect you have a page break set there.

  7. #7
    pharrison74 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2016
    Posts
    114
    It is set to none. Here is a screen shot. Thanks again for all your help.

    Click image for larger version. 

Name:	Capture.3JPG.JPG 
Views:	13 
Size:	39.0 KB 
ID:	23573

  8. #8
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    So no solution then? I'm out of ideas, I'm afraid - unless you want to post a zipped copy of your db.

  9. #9
    pharrison74 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2016
    Posts
    114
    Here you go.. Got rid of all the data as it cannot be show. As well as some report.However the report I am having issues with is there.

    Thanks
    PeterTesting_Litigation.zip

  10. #10
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I guess you did not notice my profile - I'm stuck in 2007 and can't open your file. You'd have to save as 2007 first. However, if there's no data at all, the report will be of no use. I understand if you can't include any real data and don't have the time to enter any fake data. That would be true for anyone who could open your db, I think.

  11. #11
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I agree with Micron --little or no data will probably hide the issue.

    Can you make a fake record or 2 or 3. Just garbled text or copy some text from internet or a file just to get some volume.
    For names and cities type info use things like Porky Pig, General Purpose, Sheza Winner....
    Big City, Centretown, LittleRock... get creative.

  12. #12
    pharrison74 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2016
    Posts
    114
    There is data in the db just junk data.. The issue does come up when you open the report.
    I don't seem to have the option to save it as Access 2007 file...Unless I am missing someting

  13. #13
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    With no form/report etc. object selected, Office button > Save As > 2007
    At least that's what I see with my version.

  14. #14
    pharrison74 is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2016
    Posts
    114
    The only option I have is 2003 and even then it says I can't due to missing items.
    God why does microsoft make things so difficult.

  15. #15
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Sorry, sometimes works, sometimes not. As long as you have enough data to produce a report, I'm sure someone else will jump in. If not, you could try opening a new db, save as (2003 is fine) and import your report, tables and queries and whatever else is needed. It'll likely complain about some features not being compatible, but hopefully will do the import anyway.

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 05-07-2015, 02:55 PM
  2. Record is too large
    By james28 in forum Access
    Replies: 6
    Last Post: 08-04-2014, 06:01 AM
  3. Replies: 11
    Last Post: 03-13-2014, 09:54 AM
  4. large DB issue
    By maximax in forum Access
    Replies: 4
    Last Post: 02-23-2012, 08:51 AM
  5. Replies: 1
    Last Post: 04-03-2010, 09:35 PM

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