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!
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.
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.
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
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.
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
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?
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
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?