Form sized to design window even though AutoResize = yes (Access 2003)

[Chippy]

This is driving me NUTZ.

All of my forms are keeping the size of the window I design them in, even
when I have the AutoResize option set to Yes.
The actual form (grey, gridded area) is the size I want it, but the window
it opens in is NOT this size.

This applies if I open the form directly, even if I then choose "Window,
Size to fit form".
I know the form stays the size of the design window when I switch to view
mode from design mode, but I can't get the form to resize correctly
anywhere!

I've tried adding:
With DoCmd
.Restore
.RunCommand acCmdSizeToFitForm
End With
to the Form_Open event, with no luck either.

I've tried changing the CanGrow/CanShrink options of the
Header/Detail/Footer sections...still no change.

Any suggestions?

[salad]

Chippy wrote:

This is driving me NUTZ.

All of my forms are keeping the size of the window I design them in, even
when I have the AutoResize option set to Yes.
The actual form (grey, gridded area) is the size I want it, but the window
it opens in is NOT this size.

This applies if I open the form directly, even if I then choose "Window,
Size to fit form".
I know the form stays the size of the design window when I switch to view
mode from design mode, but I can't get the form to resize correctly
anywhere!

I've tried adding:
With DoCmd
.Restore
.RunCommand acCmdSizeToFitForm
End With
to the Form_Open event, with no luck either.

I've tried changing the CanGrow/CanShrink options of the
Header/Detail/Footer sections...still no change.

Any suggestions?

Do you have the form set to Sizeable? (see BorderStyle in form's Format
settings)

Do you have the form set to modal or dialog? Check the Other tab for
the form's properties.

[Chippy]

Border Style = Sizeable
PopUp = No
Modal = No

What should they be set to?
I want to use these forms as subforms on a tab control so I want to make
sure they are all sized correctly.

thanks for your help

[BTW: Surely MS would realise that by default most people would want the
form to be the size of the form and not the window you design it on?]

[Lyle Fairfield]

I suggest:

a) posting all your form module so that we might consider the problem
with as much information as possible;

or

b) trying

Private Sub Form_Load()
DoCmd.RunCommand acCmdSizeToFitForm
End Sub

Private Sub Form_Open(Cancel As Integer)
With Me
..InsideHeight = .Section(acDetail).Height * 20
'me.note is the "righthand-most" control on the form
..InsideWidth = Me.Note.Left + Me.Note.Width + 64
End With
End Sub

with modifications appropriate to your wishes and the form's design.
The event in which these codes are run does seem to be quite important
not surprsingly as it's difficult to size the from window before it
exists; I have never had consistent success with
With DoCmd
.Restore
.RunCommand acCmdSizeToFitForm
End With
in the Form_Open Event, but I have in the Form_Load Event.

[Rick Brandt]

Chippy wrote:

Border Style = Sizeable
PopUp = No
Modal = No

What should they be set to?
I want to use these forms as subforms on a tab control so I want to
make sure they are all sized correctly.

thanks for your help

[BTW: Surely MS would realise that by default most people would want
the form to be the size of the form and not the window you design it
on?]

While I agree with you about wanting to figure out what is going on with the
window sizes that will have zero affect on the form when used as a subform.
You will size the subform control to make it contain the form content.
There is no "window size" in that context.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Chippy]

Look at the "Session_Strength" form as an example of one that stays the size
of the window and not the form

[Rick Brandt]

Chippy wrote:

Look at the "Session_Strength" form as an example of one that stays
the size of the window and not the form

And just where would we see this form? Have you posted this on a web site
somewhere?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Chippy]

It's attached in a previous post (through newgroups)

[Chippy]

Found my answer by trial and error...

Needed to set the Form, Format, Default View property to Single Form
DOH!

[Lyle Fairfield]

Well, I'm glad MS doesn't have to issue a formal apology to you.

[Rick Brandt]

"Chippy" <ch**********@hotmail.com> wrote in message
news:dr**********@newsg1.svr.pol.co.uk...

It's attached in a previous post (through newgroups)

Ah, my server (and many others) don't accept attachments.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Terry Kreft]

If you open the form in design view and then switch to form view this will
happen.

Does it still happen if you open straight to form view?

--

Terry Kreft
"Chippy" <ch**********@hotmail.com> wrote in message
news:dr**********@news6.svr.pol.co.uk...

This is driving me NUTZ.

All of my forms are keeping the size of the window I design them in, even
when I have the AutoResize option set to Yes.
The actual form (grey, gridded area) is the size I want it, but the window
it opens in is NOT this size.

This applies if I open the form directly, even if I then choose "Window,
Size to fit form".
I know the form stays the size of the design window when I switch to view
mode from design mode, but I can't get the form to resize correctly
anywhere!

I've tried adding:
With DoCmd
.Restore
.RunCommand acCmdSizeToFitForm
End With
to the Form_Open event, with no luck either.

I've tried changing the CanGrow/CanShrink options of the
Header/Detail/Footer sections...still no change.

Any suggestions?