Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 167
  • Last Modified:

Access 2013 Form Maxmize not working

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
nigelr99
Asked:
nigelr99
  • 8
  • 3
  • 2
1 Solution
 
Dale FyeCommented:
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
 
nigelr99Author Commented:
Hi,
Form is in overlapping mode and the docmd.maximize command is in the Form Load event. Border style is 'None'.
0
 
Dale FyeCommented:
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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
nigelr99Author Commented:
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
 
nigelr99Author Commented:
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
 
nigelr99Author Commented:
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
 
Gustav BrockCIOCommented:
What happens if you open the form maximized with DoCmd:

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

/gustav
0
 
nigelr99Author Commented:
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
 
Gustav BrockCIOCommented:
Try to open the login form from the OnLoad event of the main form or the OnCurrent event.

/gustav
0
 
nigelr99Author Commented:
Shall do - will try out of hours next chance I get!
0
 
nigelr99Author Commented:
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
 
Gustav BrockCIOCommented:
Then you should open the form hidden, and then unhide it after the maximize command - or right before.

/gustav
0
 
nigelr99Author Commented:
Best solution to inexplicable problem?
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

  • 8
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now