Solved

Access 2013 Form Maxmize not working

Posted on 2014-09-28
13
134 Views
Last Modified: 2014-11-19
Hi,
I have an Access app whereby the main form is maximised on opening to act as 'kiosk mode' effectively. This has worked fine for around 2 years using 2007 runtime but now that I've upgraded to 2013 (full office version installed), sometimes (which is annoying part), the form 'maximises' but leaves a small border around the edge of the screen. The Access application window is full screen and you can actually see remnants of Access itself around the edge.
Has anyone seen this behaviour before, I cannot find any similar issues on the web?
Thanks
0
Comment
Question by:nigelr99
  • 8
  • 3
  • 2
13 Comments
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 40348918
Is the form in tabbed or Overlapping windows mode?

Are you issuing the docmd.Maximize command in the Forms Open event?  If not, how are you ensuring that it is maximized?

What is the forms Border Style set to?
0
 

Author Comment

by:nigelr99
ID: 40349679
Hi,
Form is in overlapping mode and the docmd.maximize command is in the Form Load event. Border style is 'None'.
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 40349758
I don't have 2013 on my laptop, so cannot test, but I do not recall ever encountering this, although I rarely go into Maximized mode on my forms.
0
 

Author Comment

by:nigelr99
ID: 40349765
I'm trialling moving docmd.maxmize into form_open so will post result here in day or so - looks like it might be as simple as that so fingers crossed!
0
 

Author Comment

by:nigelr99
ID: 40379252
Apologies for slow response, it seems putting maximise into form_open only partially fixed the problem and other issues are at play. To add some more detail to my scenario, my application runs on 7 identical pcs and consists of a main form which is the first to open and then maximised as stated. As a subsequent part of the form_load event, I open a login form in dialog / pop-up mode.

 My findings are:
1. On some machines, Access takes quite a while to start (which is another baffling occurrence at the moment) and in this scenario, the login form appears but the main form does not and this invariably results in the main form eventually appearing when the login form is closed but with the edges cropped as described previously. It seems it's cropped to the size of the Access window when not maximised.

2. As a further part of the application, other forms are opened and on one in particular it seems that (sometimes), the main form reverts to it's cropped state when the secondary form closed.

Has anyone else ever encountered this behaviour? It's driven me round the bend, especially as it doesn't happen all the time or on the same pc(s).
Thanks
0
 

Author Comment

by:nigelr99
ID: 40391623
No-one? As an example, I've attached a screen-shot (very small for various reasons) but if you look, you'll see a white border around the edge of the blue form. I re-sized the form manually as large as I could so it's still useable but it's cropped around the edge with Access showing 'behind'. The area actually shown appears to be the form 'size'.
This has to be an Access 'bug'? Any help appreciatedSample thumbnail screen-shot of maximised form / cropped border
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 49

Expert Comment

by:Gustav Brock
ID: 40391747
What happens if you open the form maximized with DoCmd:

DoCmd.OpenForm "FormName"
DoCmd.SelectObject acForm , "FormName"
DoCmd.Maximize

/gustav
0
 

Author Comment

by:nigelr99
ID: 40401831
Slow reply sorry - trying to recreate on test system but inevitably that works perfectly every time.

Your suggestion works fine but the form in question is actually set as the first form to open when database starts (via db options) and what actually happens is .. Access starts / screen remains 'blank' / white , then my login form appears which is opened by the main form.  When the login form is then closed, the main form displays but cropped to it's 'design size', even though it's contents are maximised. So weird and happening on multiple pcs / windows 7 and windows 8.

What should be happening of course (and does some of the time) is that the main form is displayed, then the login form opens on top of it.
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 40401864
Try to open the login form from the OnLoad event of the main form or the OnCurrent event.

/gustav
0
 

Author Comment

by:nigelr99
ID: 40401880
Shall do - will try out of hours next chance I get!
0
 

Accepted Solution

by:
nigelr99 earned 0 total points
ID: 40442411
Ridiculous amount of time later but.. the only way I can solve this problem is to move the maximise command to the end of the sub, i.e. after the login form is opened. Initially this leaves the login form displayed on top of the 'empty' Access workspace but this is a small price to pay I guess. After doing this, I've had no issues with the main form being cropped - still convinced it's a bug though!

I guess I just accept this as the solution although it's not exactly 'satisfying!'
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 40442556
Then you should open the form hidden, and then unhide it after the maximize command - or right before.

/gustav
0
 

Author Closing Comment

by:nigelr99
ID: 40451931
Best solution to inexplicable problem?
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 will show you how to use shortcut menus in the Access run-time environment.
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
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…

911 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

23 Experts available now in Live!

Get 1:1 Help Now