"Brian Keanie" wrote in
... have a form and a subform. On the
subform I have a button which opens
another form to give info as to input.
When I return to main form and subform
the entire form is distorted and shrunk in
size. To return it to proper size need to
put it into design view and maximise it.
Any thoughts?
Copy and paste the DoCmd.OpenForm statement used to open the other Form.
Also, check the Open and Load events for statements that Maximize or Restore
the Form.
Unless you have opened the data entry Form as Dialog, whatever choice you
make for it (e.g., Restore or Maximize) will apply to all the other Forms
that are Open, as well -- that's the way Access works. However, clicking on
the Maximize button in the top bar of the original Form, once you are back
there, should maximize it -- that's the button that looks like a box with a
slightly heavier top line. You shouldn't have to go into Design view to do
so.
If you have suppressed the display of those buttons because you think the
user "ought to" view the Form in a particular mode, I'd caution that "the
Windows Way" is that the user owns his/her own desktop and should be allowed
to size/resize objects thereon to his/her own wishes. You are likely to have
a much happier user audience if you don't force your own wishes on them.
Larry Linson
Microsoft Access MVP