?
Solved

Access 2007 Split forms will not maintain set sizes

Posted on 2009-03-29
15
Medium Priority
?
2,089 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses
Course of the Month15 days, 4 hours left to enroll

771 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