Solved

Access 2013 Form Maxmize not working

Posted on 2014-09-28
13
127 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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

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

13 Experts available now in Live!

Get 1:1 Help Now