• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 111
  • Last Modified:

Access 2013 - Forms

My OS is win 7 prof 64 bit and i use Access 2013.  I have a small app, and when the Form is opened when the App is loaded, the Form is maximized in that I am unable to hit the X button to close it.  Is there a way to load the Form by code, so that it occupies about 95% of the screen, so that I can  click on the task bars to move it around.  Thank u for your suggestion.
0
jegajothy
Asked:
jegajothy
  • 5
  • 4
  • 3
1 Solution
 
Dale FyeCommented:
You should be able to use the Forms Move method, which lets you position the form and size it all in one.

Private Sub Form_Open

    me.Move 1440, 1440,  9*1440, 9*1440

End Sub

This should make the form 9"x9" and offset it 1" from the bottom of the ribbon and 1" from the right margin of the navpane
0
 
Dale FyeCommented:
Assumes that you have the forms configured for overlapping windows, not tabs, which is the default in later versions of Access.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Noting that 1440 Twips = one inch, and the parameters for move are in Twips.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
jegajothyAuthor Commented:
In response to Date Eye, thank u for the code  solution,  it works.   Gracias
0
 
Dale FyeCommented:
You're welcome.

BTW, that's "Fye", not "Eye"
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I thought it was Fried ... humm
0
 
Dale FyeCommented:
Yeah, Joe, there has been a lot of that lately too.  One of these days, I'll find some time to finish the CommandBarTool.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
It's really close ...
If you could just fix that last minor issue .. about no equals sign in front of - what would be a Macro name - in the Parameter property
0
 
jegajothyAuthor Commented:
in response to DatabaseMX, I am not sure I understand what u are trying to convey, hope u could please give in solution form.  Thank u for your participation.
0
 
Dale FyeCommented:
jegajothy,

Sorry, that was just a discussion between MX and me.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Sorry ...
0
 
jegajothyAuthor Commented:
thank u.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now