Results 1 to 5 of 5
  1. #1
    Frannilea is offline Novice
    Windows 10 Access 2007
    Join Date
    Jul 2020
    Posts
    27

    Form is Cut Off at the Bottom

    Hi.

    I looked everywhere for an answer to this, which seems such a silly simple problem that should be easy to find an answer to. But there were only people complaining about reports and subforms. This is just a standard once off form and none of the other answers helped me.

    I have a form that is being cut off at the bottom. Sure, there are scroll bars, but why is there a blank space below the form where I should see the bottom. It's forcing me to use the scroll bars when there is plenty of room on my screen to see the bottom of my form, except it's just blank. How do I change that? I read that the maximum length of a form is 22 inch. My form is less than half that = 22 cm in total as you can see in the second picture, but it's not even displaying the whole of that.

    See pictures below. How do I see ALL of my form, filling the blank space instead of having to scroll down? The "form" property has a form "Width", but no form "Height".

    Thanks in advance.

    Click image for larger version. 

Name:	Form Length - Form View.jpg 
Views:	28 
Size:	128.4 KB 
ID:	51604
    As you can see there is blank space, but I still have to scroll down? How do I make Access use ALL the space available within the window?



    Click image for larger version. 

Name:	Form Length - Design View.jpg 
Views:	27 
Size:	190.6 KB 
ID:	51603
    My form is longer than is displayed.

    Click image for larger version. 

Name:	Form Length - Properties.jpg 
Views:	27 
Size:	223.1 KB 
ID:	51605
    Here are my form properties.

  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
    Each section has Height property. Form Header and Footer heights take precedence and Detail gets what's left.

    If there are no controls within the form footer, reduce its height to zero.
    Last edited by June7; 03-17-2024 at 11:22 AM.
    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
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,977
    Also reduce the height of the detail section to remove any blank space

    P.S. Congratulations. You get this year's award for the best Barbie database
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  4. #4
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,474
    P.S. Congratulations. You get this year's award for the best Barbie database
    Hey this is probably how Candy Crush got started....
    Last edited by Bulzie; 03-19-2024 at 01:11 PM.

  5. #5
    Frannilea is offline Novice
    Windows 10 Access 2007
    Join Date
    Jul 2020
    Posts
    27
    Haha! Thank you for the answer! It's exactly what I needed. Yes, my database looks horribly like a flamingo threw up on it. DD:: I'm not exactly in love with it's aesthetics either, but hopefully it'll make some rather reluctant 10 year old English learners feel more congenial to learning English. That and the promised candy...actually, probably mostly the promised candy, but it doesn't hurt to add a little more sugar...

    PS: I tried it out on my kids and it was a success!! Thanks for all the help!!

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

Similar Threads

  1. Cut Off at Bottom of Form View
    By wscwt01 in forum Forms
    Replies: 21
    Last Post: 02-15-2022, 09:42 AM
  2. Best way to sum totals at bottom of form
    By tagteam in forum Access
    Replies: 6
    Last Post: 10-29-2021, 10:34 AM
  3. Replies: 3
    Last Post: 03-11-2015, 08:05 PM
  4. Replies: 5
    Last Post: 02-20-2014, 11:05 AM
  5. can't update form-in the bottom bar of
    By ymds in forum Access
    Replies: 2
    Last Post: 07-19-2010, 06:26 AM

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