Split Form Issue

Skip Bisconer

Who Me?
Local time
Today, 13:51
Joined
Jan 22, 2008
Messages
285
I have a form to input to a table with only three columns of data and when I run this form it opens in full screen. I tried to use the docmd.movesize to no avail. Then I set the popup property to yes with the docmd. movesize and I get an "Invalid outside procedure" noticeon loading which, when bypassed, opens the form in full screen. Am I missing something or does the split form always open in full screen?
 
Last edited:
Are you using tabbed forms or overlapping windows?
 
No just a regular single split form.
 
What are these "split forms" that people keep saying? I'm confused
 
What are these "split forms" that people keep saying? I'm confused

Ray:

A split form is one new 2007 creation where it will, based on your recordsource, have it show two views of your data. The first is a datasheet which shows all records of your recordset. The other is a single view of whichever record has been selected, so you can edit it.

The benefit also includes that you don't have to have all of the fields showing in the datasheet and then you do your update in the single form view for the individual record. And it is all synched automatically by Access.
 
Ray:

A split form is one new 2007 creation where it will, based on your recordsource, have it show two views of your data. The first is a datasheet which shows all records of your recordset. The other is a single view of whichever record has been selected, so you can edit it.

The benefit also includes that you don't have to have all of the fields showing in the datasheet and then you do your update in the single form view for the individual record. And it is all synched automatically by Access.

Had been using access 2007 for over a year, 2010 now, and have never noticed that before.. Thanks Bob..
 
I had my database set to tab view and changed it to Overlapping widows rebooted the database and it still opens to full screen. I have my min/max property enabled but it will not minimize, just stays maximized. I have now set it back to tab documents.
 
tabbed documents will open basically full screen.

In order to change to the other not full screen, you need to set overlapping windows, then go into form view and resize your window to the way you want it (make sure that auto resize is set to NO) and then click the SAVE button so it will save the size of the window.
 
Thanks Bob,

I am now able to use the docmd.movesize so the form is looking good. I have another problem with vba so will go to that forum. Thanks to all of you for your valuable input.
 

Users who are viewing this thread

Back
Top Bottom