Form sizing issue

  • Thread starter Thread starter Beth
  • Start date Start date
B

Beth

In my database I have one form with a running list of students. When you
select a name from the list, I want it to open the students form to that
student's record as a dialog form so that I can have some code wait for the
student form to close before it runs.
The code is DoCmd.OpenForm "frmStudents", acNormal, , "StudentID =
Forms!frmStudents.StudentID", acFormEdit, acDialog

All that works fine except that when the Student form opens, it maximizes,
removes the toolbars at the top and even covers the Windows start bar at the
bottom of the screen. I have played with settings, but I can't get it to
maximize within the database frame, leaving the taskbar and toolbars.

What is the setting that I have wrong? Thanks!

Beth
 
Beth said:
In my database I have one form with a running list of students. When you
select a name from the list, I want it to open the students form to that
student's record as a dialog form so that I can have some code wait for the
student form to close before it runs.
The code is DoCmd.OpenForm "frmStudents", acNormal, , "StudentID =
Forms!frmStudents.StudentID", acFormEdit, acDialog

All that works fine except that when the Student form opens, it maximizes,
removes the toolbars at the top and even covers the Windows start bar at the
bottom of the screen. I have played with settings, but I can't get it to
maximize within the database frame, leaving the taskbar and toolbars.

What is the setting that I have wrong? Thanks!


AFAIK, What you did wrong was maximize the student form in
dialog mode. Dialog and popup forms are not confined to the
Access window.

Instead of using DoCmd.Maximize, use DoCmd.MoveSize to make
the form large, but not too big.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top