×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Maximize Form when menus disappear

Maximize Form when menus disappear

Maximize Form when menus disappear

(OP)
To print reports, I have a pop up form with report selections.  The reports are all printed to screen first.  The Print Reports Menu appears when the reports come to screen.  When I close out the report and the pop-up form, it leaves a gap at the top of the screen between my main form and the standard access menu.  In other words, my main form is no longer maximized.  

Any suggestions on how to solve this problem.

RE: Maximize Form when menus disappear

I use a small macro (which I called 'Fullscreen') which is activated by the 'On Open' Property of the Main Form.

First create the new Macro (called Fullscreen), set Action to 'Maximise', save macro as 'Fullscreen'.

Then go to your form's design view, click on the Event tab, select the 'On Open' property and type (or select from the drop down) Fullscreen. Save your form.

Now each time you open the form it will be maximised.

Is this what you are trying to acheive?

RE: Maximize Form when menus disappear

(OP)
Not exactly, that works the first time the forms is opened.  

In my case, the form is still opened with a pop-up form and report printed to screen opened on top of it.  When the report is closed, the print report menu disappears also, leaving an empty area at the top of the form.  

The form needs to be maximized again at this point.

RE: Maximize Form when menus disappear

Okay I understand.
Try putting the 'Fullscreen' macro in the 'On Activate' property field. This worked for me!!

RE: Maximize Form when menus disappear

I almost agree but would instead put in the code for On Activate.  "DoCmd.Maximise"  The code is easier and macros should always be avoided if possible.  This way the code is attached to the form and if the form is ever exported the macro does not need to be exported as well.
Private Sub Form_Activate()
DoCmd.Maximize
End Sub

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close