 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Macros / December 2006MoveSize doesn't work?
I have a macro with 2 steps: OpenForm & MoveSize The properties in OpenForm are: View = Form Window Mode = Dialog When the macro runs, the form opens up in the upper left corner of the screen no matter what dimensions I enter into the MoveSize property. I have numerous other forms and I have never had this happen. Is there a property in the form that may override the macro? Any suggestions are appreciated! Slez Slez, A am not sure, just some ideas to check out... Depending on your version of Access, the form has a Moveable property, so make sure this is set to Yes. Do you see the same problem if you open the form with Window Mode = Normal?  SignatureSteve Schapel, Microsoft Access MVP > I have a macro with 2 steps: OpenForm & MoveSize > [quoted text clipped - 10 lines] > Any suggestions are appreciated! > Slez Thanks for the response! Moveable property is set to yes. When window mode is Normal, it opens maximized. Strange issue...if you think of anything else that might cause this, I'll appreciate the suggestion! Slez >Slez, > [quoted text clipped - 10 lines] >> Any suggestions are appreciated! >> Slez >I have a macro with 2 steps: OpenForm & MoveSize > [quoted text clipped - 10 lines] >Any suggestions are appreciated! >Slez Are you actually calling your macro in the forms Open Event? Just a thought. One other thing, try to steer clear of macros. You can use VBA instead. Private Sub Form_Open(Cancel As Integer) DoCmd.MoveSize 123, 5, 11750, 4700 End Sub SignatureDavid Of course I wasn't calling it out in the Open event! That fixed it! Sometimes I wonder about myself! Thanks! In your example of VBA, what do your dimensions represent? In the macro sizes read: 2", 2", 4.5", and so on. Slez >>I have a macro with 2 steps: OpenForm & MoveSize >> [quoted text clipped - 8 lines] >DoCmd.MoveSize 123, 5, 11750, 4700 >End Sub When you're using the MoveSize method (as opposed to the MoveSize action), all arguments are expressed in twips. There are 1440 twips to the inch, or 567 twips to the centimeter. If you're currently thinking in inches, just multiple the inch value by 1440. SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) > Of course I wasn't calling it out in the Open event! That fixed it! > Sometimes I wonder about myself! Thanks! [quoted text clipped - 17 lines] >>DoCmd.MoveSize 123, 5, 11750, 4700 >>End Sub |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.