I want to adjust the size of a form for the best fit of controls that will be
visible when the form opens. My form is pop-up, model and dialog border.
The following code in the Open event of the form has no effect.

Me.Detail.Height = 2700
Me.Width = 3240
Help please.
--
Thank you,
Del

On Wed, 15 Jun 2005 10:29:11 -0700, Del wrote:

> I want to adjust the size of a form for the best fit of controls that will be
> visible when the form opens. My form is pop-up, model and dialog border.
> The following code in the Open event of the form has no effect.
>
> Me.Detail.Height = 2700
> Me.Width = 3240
> Help please.

You adjust the size of the entire form, not just a section.
Look up the MoveSize method in VBA Help.

Docmd.MoveSize , , 3*1440, 2 *1440

Will set the form width to 3" and it's height to 2"
All measurements are in Twips (1440 per inch).
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.