Opening forms in a library reference to an external database, I use the for
the OnOpen Event

DoCmd.SelectObject acForm, Me.Name
DoCmd.Restore

The size seems very variable, in particular, continuous forms open only1
record high + header & footer. Forms from the main Db open as expected.

Any bright ideas please

Phil

On 2/17/2011 7:40 PM, Phil wrote:
You might call DoCmd.Restore before opening the form.

Is the form property set for Auto Resize? Setting it to True usually
works, but if you want to manually set a size, you should set it False,
resize it manually, and save it.

Why are you calling DoCmd.SelectObject using Me.Name? It does not seem
necessary. When you open a form, it normally gets the focus automatically.

Also, doing it in the form Open event is a little strange, since the
form is normally not yet open and visible at that time (although perhaps
the SelectObject forces it to become visible). Perhaps the OnLoad event
would be better, after the form has been displayed in the normal case.

Steve

On 18/02/2011 11:53:31, Sky wrote:
Thanks for coming back, Steve. No joy. Form set to Auto resize, and tried the
Restore in the OnLoad event. Incidently I always do
DoCmd.SelectObject acForm, Me.Name
DoCmd.Restore
in the OnOpen event and it always works for forms in the main database.
Please don't think I am rude, but I posted am additional message "Restore /
Maximize" in this NG on 18th Feb, and it seems silly to run 2 threads on the
subject, so would appreciate your input on that thread Thanks

Phil

On 18/02/2011 11:53:31, Sky wrote:
Thanks for coming back, Steve. No joy. Form set to Auto resize, and tried the
Restore in the OnLoad event. Incidently I always do
DoCmd.SelectObject acForm, Me.Name
DoCmd.Restore
in the OnOpen event and it always works for forms in the main database.
Please don't think I am rude, but I posted am additional message "Restore /
Maximize" in this NG on 18th Feb, and it seems silly to run 2 threads on the
subject, so would appreciate your input on that thread Thanks

Phil