When I open a form, it initially fits the whole screen. If I change to another window (the form is still open) OR go into design view of the form , the size of the form is reduced in size when I return back to form view of the form.

How do I ensure that when I return to the form that the size maximises automatically?

use the restore action

Where do I place this?

Try putting it on the OnActivate of the form. Is you forms either set to Pop-up or Modul or are you trying to hide the Close/Min Max buttons?

To supplement DBL's answer. You can put it in a macro to run OnActivate.

Col
Hi Dawn !

DoCmd.Maximise in the on load event

Doesn't seem to work. The forms is neither Popup or Modal. Also the Close button is set to No.

I discovered that the form's Border Style property was set to Dialog. Changing this to Sizable cured the problem.

Thanks Rich. I hadn't seen your post before my last reply. Your suggestion worked.

I would have thought that the Restore action\method would also have worked in the Activate event?

Never found the Activate event to be useful for anything http://www.access-programmers.co.uk/ubb/smile.gif