By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,458 Members | 1,215 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,458 IT Pros & Developers. It's quick & easy.

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

P: n/a
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?
Jan 25 '06 #1
Share this Question
Share on Google+
11 Replies


P: n/a
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.
Jan 25 '06 #2

P: n/a
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?]
Jan 25 '06 #3

P: n/a
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.

Jan 25 '06 #4

P: n/a
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
Jan 25 '06 #5

P: n/a
Look at the "Session_Strength" form as an example of one that stays the size
of the window and not the form
Jan 25 '06 #6

P: n/a
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
Jan 25 '06 #7

P: n/a
It's attached in a previous post (through newgroups)
Jan 25 '06 #8

P: n/a
Found my answer by trial and error...

Needed to set the Form, Format, Default View property to Single Form
DOH!
Jan 25 '06 #9

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

Jan 25 '06 #10

P: n/a
"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
Jan 25 '06 #11

P: n/a
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?

Jan 26 '06 #12

This discussion thread is closed

Replies have been disabled for this discussion.