[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Access 2013 Form Maxmize not working

Posted on 2014-09-28
13
Medium Priority
?
173 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 49

Expert Comment

by:Dale Fye
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 49

Expert Comment

by:Dale Fye
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 

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

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 53

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 53

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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

Implementing simple internal controls in the Microsoft Access application.
Are you looking to start a business? Do you own and operate a small company? If so, here are some courses you need to take before you hire a full-time IT staff.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
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…

640 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