Results 1 to 4 of 4
  1. #1
    krag is offline Medium experience
    Windows 10 Office 365
    Join Date
    May 2014
    Posts
    71

    Overlap a small subform over a large subform's free space in the middle

    I have a main form with 2 subforms (both continuous forms).


    For the sake of layout of data, some columns of the large subform should come at the extreme right end.
    The smaller subform should fit in the empty space between the left side and right side columns of the large subform.
    When I designed this way, the small subform gets completely hidden under the large subform.
    Is there any property of subform to program it to bring it above or below another subform?
    If there is no way, then only solution for me is to make a third subform for the right side columns of the large subform.
    This would involve programming all the control links from the left side main part of the large subform and perhaps it is not impossible but cumbersome.
    Look forward to your help if available.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    I have to say "no" in answer to your question.

    Go with your idea as fix or make big subform Single mode and install smaller subform on bigger one.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,801
    Maybe if you made the smaller subform a popup, but you might have to make it modal as well and that likely won't work. AFAIK, Access does not provide for controlling z order (layering) which I think is what you'd need. Did you consider a tab control with pages?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    krag is offline Medium experience
    Windows 10 Office 365
    Join Date
    May 2014
    Posts
    71
    Thanks June7 and Micron.
    I guess there is no easy solution but to split the large subform.
    Both subforms are pop-up.
    I tried modal for small subform but there is no change.

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

Similar Threads

  1. Blank Space appearing on Subform
    By PaulaYoung in forum Forms
    Replies: 10
    Last Post: 04-27-2022, 06:18 PM
  2. Replies: 4
    Last Post: 12-14-2016, 11:07 AM
  3. Replies: 1
    Last Post: 12-05-2016, 02:23 PM
  4. Replies: 2
    Last Post: 03-14-2014, 05:42 PM
  5. Hide subform and clear the space left
    By blueraincoat in forum Forms
    Replies: 7
    Last Post: 03-24-2011, 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