Results 1 to 12 of 12
  1. #1
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167

    Unanswered: Access 2007 Form Borders Resizing Incorrectly

    Yesterday I ran a database in Access 2007. I opened a form and noticed that it had resized the width automatically, making the form wider than it should be. I dragged the window in design view making it smaller when I viewed in form view. However, after I saved the form, closed and reopened it, it had reverted back to the wide size. I feel like I've tried every possible combination of property settings regarding resizing and auto centering but I cannot figure out how to get it to keep the size I specify constant.

    Has anyone else found a solution for this or is this just another quirky Microsoft Access 2007 abuse? If so, can someone tell me a good place to buy a used legitimate copy of 2003? Thanks!

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I haven't run into this problem before and I manage about 10 2007 databases.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167
    That's strange. What kind of forms do you have in those databases? I was using a tabular form. Did you create those forms in 2007 or previous versions and then open in 2007? I had seen a post regarding this same issue on an other forum however it was left unresolved after several suggestions.

    My problem is just that I can manually adjust the size all I want, even to the point that the form view yields acceptable results, however, when I close and open the form, it resizes the form width so that it's about 50% too wide, even though there are no objects in that extra space.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Both... single forms, continuous forms... subforms. And both, databases written in 2003 and used by Access 2007 and native Access 2007 files.

    To resize it are you taking the right steps?

    Open the form in design, size the form to where you want it, hit save then close. You can be tricked if you forget to save it and then test it immediately... hitting the close button at that point will not prompt you to save and the change is lost.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167
    Yes, I've tried this. I made sure the width was correct in the properties and I adjusted the window size as well and saved it when it produced a correct looking form. After this I closed the form but usually within a couple times of opening it again, the form has resized itself and is once again too wide. Joshua

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Is there any code in the form that might be affecting the window size?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  7. #7
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167
    Yes, however I'm pretty sure I had this same difficulty prior to implementing the code. The code calls a public function to resize the form on the load event. After I saw the problem remained, I removed the event but it still had that problem. Here is a post I read on the issue recently.

    Access 2007 not retaining a form's window size - Microsoft Access / VBA answers

    I still need to try some of these steps. I'm still concerned that whatever changes I make will only last temporarily. I don't mean to dis 2007. Its just with this being my introduction to it, and not being able to find controls I use regularly, you can see my frustration. Thanks, Joshua

  8. #8
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yes, I too am frustrated with the changes in 2007. What I hate most is that I knew the order of properties in the property sheet and not I spend way too much time looking through the properties for the one I want. I am still adapting...

    So do you have Auto Resize set to Yes for the form?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  9. #9
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167
    I have tried Auto Resize set to yes and no. Could you possibly include a screenshot of property settings for a form of yours which is properly maintaining dimmensions? That might help clear things up. Joshua

  10. #10
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I doubt that would help. I don't have any forms that DON'T maintain their dimensions. With like 10,000 forms to choose from... my "normal" settings have:

    Popup: No
    Modal: No
    Default View: Single Form
    Auto Centre: Yes
    Auto Resize: Yes
    Fit to Screen: No
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  11. #11
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167
    Yeah, I know but will check out just to see if it is the issue. Thanks for the help! Joshua

  12. #12
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You're welcome.

    You know, I wouldn't be at all surprised if this turns out to be the result of a 2007 conversion corruption thing... you might have to try importing your objects into a new 2007 database -- created with 2007?

    Just guessing really...
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •