Access 2007 Split forms will not maintain set sizes
Posted on 2009-03-29
I am working with a Split Form in Access 2007 and even though I set the size in design mode and then save the form, the form still opens up huge. I have the form set to Pop Up with the Border style as Sizable, the Auto Resize = NO, AutoCenter = Yes.
According to the help on the AutoResize property - When opened, the Form window has the last saved size. To save a window's size, open the form, size the window, save the form by clicking Save on the File menu, and close the form or report. When you next open the form or report, it will be the saved window size.
This seems to work OK with standard forms but with the SplitForm it blows out. I suspect it has something to do with the data sheet portion of the form. The Row Source has 12 columns and I hide all but two of them.
All I want to be able to do is resize the form and have it maintain the size next time it is opened.