Results 1 to 5 of 5
  1. #1
    ohmydatabase's Avatar
    ohmydatabase is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2017
    Posts
    79

    Angry Form Will Not AutoResize No Matter What I Do (Access 2007)

    Hey Guys,



    I've imported a database from MS Access 2013 because of backward compatibility issues when sharing the database with multiple users with multiple versions of Office. None of my forms will AutoResize correctly. I have the AutoResize Property set to True and yes I have changed the Access Option to Overlapping Windows. Access still refuses to display my form in a window. It is maximized with lots of extra white space. I've tried to add the VBA command Me.AutoResize = True upon opening the form with no luck. I have my borders set to Thin and AutoCenter as True too. Access wont even show the border. I've also made sure I am closing and reopening my form when testing this. Nothing is working.

    I'm at a loss with this one...

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,740
    Are you using split forms? If so check this out...
    Private Sub Form_Load()
    DoCmd.MoveSize , , 10000, 8640
    End Sub

  3. #3
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,511
    "Fit To Screen" form property to No

  4. #4
    ohmydatabase's Avatar
    ohmydatabase is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2017
    Posts
    79
    I believe {"Fit To Screen" = No} helped
    Strangely enough, I closed that file and opened it an hour later and all my Properties seemed to work now... -_-
    Thanks for the help!

  5. #5
    ohmydatabase's Avatar
    ohmydatabase is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2017
    Posts
    79
    I'm not entirely sure what type of form I am using tbh. I just built one using an empty form in design view..

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

Similar Threads

  1. Replies: 10
    Last Post: 02-28-2017, 01:42 PM
  2. Different VBA versions matter?
    By krag in forum Programming
    Replies: 4
    Last Post: 05-23-2014, 06:36 AM
  3. only prints the same query - no matter what i have open
    By RedGoneWILD in forum Programming
    Replies: 9
    Last Post: 08-31-2010, 10:47 AM
  4. Replies: 5
    Last Post: 08-10-2010, 02:57 PM
  5. Does it Matter? Pulling fields in a query
    By Canadiangal in forum Access
    Replies: 1
    Last Post: 10-01-2009, 01:53 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