Go Back   Access World Forums > Microsoft Access Reference > Access FAQs

Closed Thread
Thread Tools Rate Thread Display Modes
Old 09-07-2009, 12:00 PM   #1
Join Date: Jun 2007
Location: Universe - Local Group - Milky Way Galaxy - Orion Arm
Posts: 5,640
Thanks: 0
Thanked 99 Times in 46 Posts
ajetrumpet has a spectacular aura about ajetrumpet has a spectacular aura about
Send a message via MSN to ajetrumpet Send a message via Yahoo to ajetrumpet
Popup Form vs. Modal Form

What's the difference!?

Well....you can learn most of what you need to know by typing either popup or modal in the help wizard in the VBA editor. BUT....there are some things that they don't tell you. I"ll point a few of them out here as well as reiterate some things that they DO tell you, but may be unclear to a normal human being...


it's simple. it stays on top of other MS Access windows. that's about all.

here are some things you CAN do when a popup form is open:
*1) Manipulate portions of other MS Access windows that are visible. including the ribbon menus, any custom menus, and navigation pane / database window.
*2) Use VBA code to manipulate any other open object

Items with a lower Z-Index than a popup form
*1) Any windows that appear via the buttons and options that are on the HOME and CREATE menus in 2007 (and equivalents in earlier versions).
*2) Non-popup objects
*3) Other popup windows opened previously to the current popup form
*4) A Modal window that has been opened.
*5) The navigation pane / database window

Items with a higher Z-Index than a popup form
*1) 2007 Ribbon Menus / Menu Bars
*2) Any windows from menus other than the ones listed in item #1 above.
*3) Other popup windows subsequently opened.

Popups are useful sometimes. Here are some good uses of them:
*1) Stop the user from clicking around at will when they're supposed to be focusing on the current form.
*2) Get the attention of the user.
*3) Indicate to a user that there is something to do with the form on screen before anything else is done.


this is not so simple, but still easy to explain. a modal form simply freezes everything else on screen except the form itself. in other words, everything on screen other than the modal form and it's children items are inaccessible (this includes the navigation pane / database window). popup objects that still appear on top of modal forms on the screen are also inaccessible, even through they're "on top".

here are some things you CAN do when a modal form is open:
*1) Manipulate the modal form
*2) Access menu bars and ribbons
*3) Use VBA code to manipulate any other open object

Items with a lower Z-Index than a modal form
*1) Non-popup objects
*2) Navigation pane / database window

Items with a higher Z-Index than a modal form
*1) 2007 Ribbon Menus / Menu Bars
*2) Any windows that appear via any menu bar option or ribbon menu item.
*3) ANY popup object, regardless of when it was opened

Modal forms are rarely useful (without being coupled with the "popup property). But, they do serve some purpose...like:
*1) Stops the user from clicking anywhere outside the modal form and having something happen on accident.
*2) when they're maximized. this plainly tells the user that something should be done with it.


in my opinion, this is by far the best option if you're gonna mess around with either of these properties at all. and here are some good reasons why:

*1) objects like this ALWAYS have the highest z-Index of all objects that are open.
*2) besides being on top, they also freeze everything else on screen, regardless of properties that are set on other objects.
*3) they are by far the best way to tell the user what to do when you have a lot of "submenus", and forms on top of forms that need to be opened to perform tasks that are buried deep inside the program.
*4) they get more attention (in my experience) if coupled with the "autoresize" and "autocenter" properties.


*1) What the heck is a z-Index? This is nothing more than a sort of stacking priority that has been set by Microsoft (or someone else) that simply regulates the question: "what is on top of what?" on the screen.
*2) Using modals and popups for security purposes are pretty much useless unless you also have the following properties set: border style<>sizable, auto center=yes, control box=no, navigation buttons=no, moveable=no, shortcut menu=no
*3) If you can help it, don't open a modal form when a popup object is already open. it doesn't kill your program or machine, but it doesn't help either. during a testing period one time, I accidentally opened a modal form that was autocentered, smaller than the autocentered popup object that I already had open, and I was using an MDE file, which was pretty much the last straw. The MDE file pretty much killed all of my "outs". So....in short, afterwards I enjoyed 5 seconds of perusing the task manager and then 1 second of hitting the "end process" button.

Last edited by ajetrumpet; 09-07-2009 at 12:14 PM.
ajetrumpet is offline  
The Following 6 Users Say Thank You to ajetrumpet For This Useful Post:
bd528 (12-21-2016), David S (01-10-2012), hassanogaibi (06-28-2016), misscrf (11-13-2012), painterz (08-02-2016), Rx_ (12-27-2012)
Old 05-05-2010, 02:48 AM   #2
Registered User
Join Date: May 2010
Posts: 1
Thanks: 0
Thanked 1 Time in 1 Post
bradsmokes is on a distinguished road
Re: Popup Form vs. Modal Form

sounds good to me
bradsmokes is offline  
The Following User Says Thank You to bradsmokes For This Useful Post:
hassanogaibi (06-28-2016)
Closed Thread

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Make Popup Form (Dialog)'s height as same as Window/Montior/Screen Height accessman2 Forms 1 05-07-2008 07:22 AM
Command Button - Find Record - Popup Form tho28199 Forms 0 04-11-2007 04:16 AM
Mouse Scroll Xenix Forms 2 10-08-2006 08:12 PM
Update form to 2nd form record amerfeld Forms 5 08-30-2005 09:15 AM
Modal Pop-up Form Problem EPD Hater General 2 04-23-2003 05:20 PM

All times are GMT -8. The time now is 02:38 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World