Keep form from sizing

[zrobinso]

I would like to keep my forms from resizing. Once a form is opend and a command button opens a smaller form, my main forms are resizing once the receive focus again. I have seen other post. But they are not working for me. Have tried these settings:

Auto Resize=No
Border= Dialog or Thin
Modal = Yes
popup= yes

Is there any code I can place behind the forms? Any help appreciated.

 

[Tofias1]

zrobinso,

I had the same problem and solved it through VB. What I did was lock the form from resizing. Then once the form opened another one I minimized the main form. Then on Close of form opened I restored the Main form. The code is as follows.
'open form through button.

Sub buttons name()

stDocName = "form1" 'form1 your form..

DoCmd.RunCommand acCmdSaveRecord
DoCmd.Minimize 'Minimzes the main Form.
DoCmd.OpenForm stDocName, , , stLinkCriteria

End Sub

'on exit on other form place this code behind form1.

Private Sub Form_Close()
stDocName = "main_form" 'Your name

DoCmd.OpenForm stDocName, , , stLinkCriteria 'Opens main.
DoCmd.Restore 'Restores main to original settings.

End Sub



Hope this helps.

Tofias1

 

[KUZZ]

THERE IS A EASIER WAY.

ON FORM PROPERTIES THERE IS A

"AUTORESIZE" CONTROL THAT SHOULD BE SET TO NO! REGARDS, KUZZ

LIFE IS GREAT WHEN THERE IS SOMEONE TO HELP YOU.
DESIGNING DATABASES SINCE 2002