MS ACCESS 2007 - Making a small pop form not full screen, when all other forms are full screen

Question

So I am sure that this is a very simple question, but I cannot figure out how to do it so here goes:

I have an Access database that basically has many forms that were designed to display full screen (I guess its the tabbed view in the options). I want to make a Splash screen for these guys but with Access 2007 it will not let me dictate the size of the form. I make the background of the detail small, and it still covers half the screen?

So what am I missing. 2003 was different from this.

Thanks Justin

Solution 1

Have you tried setting the Popup property to Yes? It's in the "Other" tab of the form properties.

Also, if you want to create a splash screen for your entire application, try creating a bitmap file with the same name as your database and save it in the same directory as your database. (For example, if your DB is example.accdb, create a file name example.bmp in the same directory.) Not sure if this works in 2007, but it did in past versions of Access.

Solution 2

If you're not in tabbed view, make sure that your form is not maximized when you save it in design mode. Or it will open maximized in view mode.

Comments

[Albert D. Kallal]

The bmp suggestion will work in 2007 and 2010 as outlined by JohnK

[Bratch]

I just followed the tip from JohnK813's answer and tested it. In MS Access 2007 I have changed my forms to popups and can click on any form behind the open form. The only thing that keeps me from click other forms behind the popup is setting the form's Modal property to Yes.