Results 1 to 3 of 3
  1. #1
    mminieri is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jun 2018
    Posts
    2

    GROUPHEADER Contents Won't Stay Where Placed

    Greetings All! I have a 9 page REPORT and using GROUP ("section") headers and footers each as the additional PAGES when printed. 2 Related Issues (both while in Report Design View);

    1) All was proceeding well until working in GROUPHEADER4 and all subsequent sections. When I MOVE any object (label, text box, etc) within that section, whatever I move JUMPS to the top of section 4 as soon as I release it.



    2) MOVING any object in GROUPHEADERS 5 and higher ALSO causes the moved object to JUMP to the top of section 4.

    I search VERY hard before asking for help .... but I can't even find a case where someone else has had this issue.

    SCREENSHOTS show BEFORE and AFTER in both issues

    Click image for larger version. 

Name:	ScreenHunter 380.jpg 
Views:	9 
Size:	80.5 KB 
ID:	34494 Click image for larger version. 

Name:	ScreenHunter 381.jpg 
Views:	9 
Size:	92.7 KB 
ID:	34495 Click image for larger version. 

Name:	ScreenHunter 382.jpg 
Views:	9 
Size:	190.4 KB 
ID:	34496 Click image for larger version. 

Name:	ScreenHunter 383.jpg 
Views:	9 
Size:	199.9 KB 
ID:	34497

  2. #2
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    The total maximum length of a report is fixed at around 22" I think, so if your design is exceeding that you will need to use subreports to get the design to fit.

    Looking at your report layout I suspect you may have a design issue if you have field / output such as Person3, this may be another reason you are struggling with the design of the report.

    Can you post up your tables design / relationships as a picture ?
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Welcome to the forum..........

    I have to agree with Minty. I would say you have a definite table design problem.

    Any time you have fields like "Per1Name", "Per2Name", "Per3Name", "Per4Name", etc, it indicates that the table is designed like a spreadsheet.
    This type of design even has a name: "Committing Spreadsheet".
    Spreadsheet designs are typically "Short and wide". Database tables are typically "Tall and Narrow".

    This is the problem with "Committing Spreadsheet": lets say you finished your dB and it is being used. Then the boss says "We need to add another person. What happens? First you must modify the table(s). In your case, it looks like you would have to add AT LEAST 10 fields. Then you would have to modify the queries, the forms , the reports and any code. I never use macros, but you would/could need to modify macros also.

    All of this just to add one more person......
    Maybe you won't ever need to add another person to the record, but you see the problem. That design also causes problems reporting the data.
    Four people in one record is not the best table design......

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

Similar Threads

  1. The s will not stay small
    By Lou_Reed in forum Access
    Replies: 5
    Last Post: 04-04-2017, 05:45 PM
  2. groupheader sizing
    By RayMilhon in forum Reports
    Replies: 9
    Last Post: 09-25-2012, 11:32 AM
  3. Replies: 5
    Last Post: 04-18-2012, 12:04 PM
  4. Replies: 0
    Last Post: 03-29-2011, 04:11 PM
  5. Length of Stay
    By lhysell in forum Queries
    Replies: 1
    Last Post: 02-02-2011, 10:45 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