Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access 2013 Form Maxmize not working

Posted on 2014-09-28
13
Medium Priority
?
160 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
[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
  • 8
  • 3
  • 2
13 Comments
 
LVL 48

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 48

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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

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 51

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 51

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 51

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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
New style of hardware planning for Microsoft Exchange server.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

715 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