Forms cascade

[Guest]

My menu loads and closes forms. In a couple of cases when a form closes and
returns to the menu form, the menu form cascades down. Initially, the menu
form fills the entire screen but upon returning to it, it appears half way
down and I have to click on the maximize icon in the upper right corner to
reposition the menu form to a full screen setting.

Why is this happening?

 

[Guest]

Do any of the forms that cause this include a line of code in the close event
such as "DoCmd.Restore"? If not, you can try placing a line of code in the
Form_Activate event procedure for your menu form that maximizes the form.

Private Sub Form_Activate()
On Error GoTo ProcError

DoCmd.Maximize

ExitProc:
Exit Sub
ProcError:
MsgBox "Error " & Err.Number & ": " & Err.Description, _
vbCritical, "Error in procedure Form_Activate..."
Resume ExitProc
End Sub


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________