Solved

Access 2007 Split forms will not maintain set sizes

Posted on 2009-03-29
15
1,928 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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
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 …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

707 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

18 Experts available now in Live!

Get 1:1 Help Now