Form is always on top

[sstasiak]

What setting controls whether a form is always on top of other windows that are open? When I click to view a report from a form I created, the report opens in the background and I have to close or minimize the form to view the report. I don't always want it on top.

 

[RuralGuy]

I think it is "Pop Up" on the Other tab of the properties sheet for the form.

 

[sstasiak]

That works, but then each form takes up the whole screen. I'd like it to look like it does in pop up mode, but not always on top. Should I be looking into modifying the format?

 

[RuralGuy]

Have you maximized something somewhere? Maximize is a system wide command so you would need to DoCmd.Restore to get your form back to normal.

 

[sstasiak]

I figured it out. Not sure if it's the same in all versions of Access, but in 2007's "Access Options" there's a tab for Current Database. In there I just changed the "Document Window Options" to "Overlapping Windows" instead of "Tabbed Documents"

 

[RuralGuy]

Glad you got it sorted.