Application window

[lchase]

Can the access application window be resized from code. I have a small start up form and would like the window to just surround it rather than leaving a 4 inch gap.
Thanks Len

 

[tman138]

Set the size of your form and use
DoCmd.RunCommand (acCmdSizeToFitForm)
to automatically resize your form to fit.

 

[lchase]

I tried it but saw no results I ran the following code using an autoexec macro
What did I miss?
Thanks Len

Public Function Main()
DoCmd.OpenForm "incomingchecksandpayments"
DoCmd.RunCommand (acCmdSizeToFitForm)

End Function

 

[SgtJarrow]

I have a sample db set up that will completely hide the access window.....might work for you...send me an email and I will forward it to you.... Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need!

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com

 

[tman138]

I think I had the syntax wrong. In your forms 'On Open' expression, paste this code:

Private Sub Form_Open(Cancel As Integer)
DoCmd.RunCommand acCmdSizeToFitForm
End Sub