Solved

Access 2007 Split forms will not maintain set sizes

Posted on 2009-03-29
15
1,955 Views
Last Modified: 2013-12-20
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.

Any ideas?
0
Comment
Question by:BladesAway
  • 5
  • 4
  • 2
  • +2
15 Comments
 
LVL 28

Expert Comment

by:TextReport
ID: 24014093
Can you provide a working example of the problem, I have been unable to recreate.
Also does the form appear to be maximized? Do you have the forms opening as Overlapping Windows or Tabbed Documents, this is set in the Access Options (from the Office Button on the Top Left), Current Database, Application Options, Document Window Option, you should be using Overlapping Windows I beleive.
Cheers, Andrew
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24016996
Can you define what you are calling "Huge", in terms of an absolute measurement please?
Or provide a screensot of the issue?
(or a sample as Andrew requests)
Thanks.

Like Andew, I could not recreate your issue, for lack of a clear definition of "Huge"

    "The Row Source has 12 columns and I hide all but two of them."
Then why not make the source for the form, just thoes two fields?
(Perhaps the split form considers "All" the available fields?)

I have attached a screenshot of a form I made, as it open normally.

JeffCoachman

untitled.JPG
0
 
LVL 1

Expert Comment

by:hunterdg
ID: 24264905
Well I'm not the OP, but i'm experiencing the EXACT same problem..

My wish:  to have the split form open either maximized (with a border) or fullscreen (with no border)
I have tried all combinations of Auto Center, Auto Resize, Fit to Screen, Border Style, Moveable, and even manually adjusting the form's size and saving (not a desirable method for a full-screen popup)

No matter what method I use, I can't get the 'split form' Form to behave.  And the Moveable:No property doesn't behave either..

FYI, as an end-result, I would like to launch this via a shortcut with properties set to 'run minimized'.
Contractor-Sign-in-driving-me-nu.mdb
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24266018
On the Open Event of the form put this:
   Docmd.Maximize

So the code will look like this:
Private Sub Form_Open(Cancel As Integer)
    DoCmd.Maximize
End Sub


0
 
LVL 28

Expert Comment

by:TextReport
ID: 24267244
As boag2000 has said the DoCmd.Maximize should do the trick, try setting the BorderStyle to Thin and include the recordselector as this visible evidence will assis you in gauging what is happening.
Cheers, Andrew
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24268987
;-)

Yes, by you setting the boderstyle to None, on the opening screen, you in effect, locked me out of the db, forcing me to us the task manager to get out.

If you are going to be submiting samples, please make it easy for the experts to see the issue directly.

;-)

Jeff
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 1

Expert Comment

by:hunterdg
ID: 24270578
@ boag2000 --- sorry..

right click>design view works like a charm though..
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24271411
OK

Keep us posted
0
 
LVL 1

Expert Comment

by:hunterdg
ID: 24271453
DoCmd.Maximize sure helps things!

the Moveable property still doesn't work.. I can double click on the title bar to 'restore' the window, and it is once again huge, and moveable..

any thoughts on why this doesn't work without the VBA?

Anyway, to fix the issue, I set border style to none.. now there is no title bar to click on at all!

Thanks for your help!
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24272560
Yes,

There are many Form properties that interact/conflict with one another.

Click each property and press the F1 Function key for help on it.

;-)

JeffCoachman
0
 

Author Comment

by:BladesAway
ID: 24630667
I resolved this issue on my own by taking a different design approach.  I am no longer using split forms.
0
 
LVL 1

Expert Comment

by:hunterdg
ID: 24715667
this is valuable information, not to mention the last comment from bladesaway is certainly within the 'last 21 days'.  Bladesaway needs to awed himself with the points, or a force-accept needs to be awarded to boag2000 as he answered the question properly.  
0
 

Accepted Solution

by:
ee_auto earned 0 total points
ID: 24752395
Question PAQ'd, 250 points refunded, and stored in the solution database.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now