Results 1 to 7 of 7
  1. #1
    data808 is offline Noob
    Windows XP Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    727

    Split Form Size

    I have a split form and was wondering how you control the sizing of the form and datasheet. My datasheet is on top and the form is on the bottom. I would like to make the datasheet larger than the form on the bottom when the split form is opened. I saw an option in properties called Split Form Size but its just set to Auto so I do not know what else I can change it to or if its even the right option to make adjustments for this.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    You can put number value in that property.

    Or you can click/grab/drag the bar that divides the top and bottom sections.
    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
    data808 is offline Noob
    Windows XP Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    727
    yeah the drag divider bar I already knew about that. I just wanted to have it set so I don't have to resize it every time that form opens. so put a number in the the property? just trial and error to find the setting I like?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Yes, I think so.
    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.

  5. #5
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Quote Originally Posted by data808 View Post

    ...I just wanted to have it set so I don't have to resize it every time that form opens...
    Actually, you can just set the Save Splitter Bar Position Property to Yes, and it'll open in the same position as it last closed in, and each user can adjust it to their preference. This Property also has to be set to Yes if you do decide to simply enter a Value in the Split Form Size Property, or it will open in the default size.

    Linq ;0)>

  6. #6
    data808 is offline Noob
    Windows XP Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    727
    Thanks for the replies. This helped a lot. Just wanted to show my appreciation for this forum. You guys are awesome.

  7. #7
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Glad we could help!

    Good luck with your project!

    Linq ;0)>

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

Similar Threads

  1. Form Size
    By MFS in forum Forms
    Replies: 10
    Last Post: 03-29-2014, 02:25 PM
  2. Get split form behaviours without using a split form
    By SyntaxSocialist in forum Queries
    Replies: 2
    Last Post: 04-12-2013, 11:56 AM
  3. Replies: 2
    Last Post: 03-20-2013, 04:25 PM
  4. Replies: 3
    Last Post: 07-19-2012, 09:27 AM
  5. Form Size
    By Rick West in forum Forms
    Replies: 1
    Last Post: 06-21-2010, 04:23 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