Is there an easy way to set form sizes?

[Guest]

Coming from a VB programming background, I expect the form size in Form View
to be that same as I set in Design View. What I get instead is extra space
on the right and bottom. Lots of it. So I have to resize the window that the
form resides in, compensating for the scroll bar widths, but that still isn't
quite right.

This is a trial-and-error process at best, and is a waste of time always.
I’ve set Auto Resize to No, but that doesn’t help.

The details section is the only part of the form showing (no headers or
footers). I’m using the form as a pop-up dialog, and both those settings are
set accordingly.

Why is this so difficult?

 

[Van T. Dinh]

Size the Form exactly as you want (not the window that contain the Form in
DesignView) and set the Auto-Resize Property to Yes/True.

When the Form is opened in formMode, the window that contain the Form will
be sized to exactly fit the Form.

 

[Guest]

Thank you for your response, but that doesn't fix the problem. I had tried
that before, and again now. The form size in Form View is that of the WINDOW
containing the form in Design View (including scroll bars), NOT the size of
the form.

This is a battle I've always fought with Access, not an isolated incidence.

BTW, I am not using Headers or Footers in the form, as this is a pop-up
dialog box. Does this make a difference?

 

[Rick Brandt]

Thank you for your response, but that doesn't fix the problem. I had
tried that before, and again now. The form size in Form View is that
of the WINDOW containing the form in Design View (including scroll
bars), NOT the size of the form.

This is a battle I've always fought with Access, not an isolated
incidence.

BTW, I am not using Headers or Footers in the form, as this is a
pop-up dialog box. Does this make a difference?

In my experience the issue you are talking about only happens with continous
forms. In the case of continuous forms the height of the form in Runtime is
determined by the height of the window the last time it was saved in design
view. AutoResize will still automatically size the width of the form on a
continuous form and it should automatically resize BOTH dimensions on a
non-continuous form.

The AutoResize only works when opening a completely closed form. If you are
moving from design view to normal view the AutoResize does nothing. I use
AutoResize on all my forms and the ONLY time I ever have to worry about the
size of my forms during normal use is when it is a continuous form and I
want to have a specific height.

 

[Guest]

Excellent answer.

If you open the form from Design View into Form View, the size gets weird.
Open it to Form View directly from a closed form and it doesn't do that. So
I need to completely close the form after designing it, then open it in Form
View.

It seems like strange, non-intuitive behavior to me.

Anyway, that you VERY much.