Form Size

[Wally Steadman]

I am creating a main form in Design View. It will just contain command
buttons that open other forms.

When I go to design view, it gives me the form canvas and the window that
the form is designed in. If I wnat the form to be 3" by 4" I can drag the
canvas to that size and it is great. But the window might be open to 8" by
9" for design room. I am making a form with THIN Borders, no resize etc...
When I save the form and display it, it is the size of the window that it
was designed in so I have to go back in to design view and move the window
size and keep going back and forth until I have the window the right size.
Isn't there a way to do this without having to resize it, check it, resize
it, check it so that the end result will be a form that is the 3" by 4" I
wanted it to be in the beginning? I hope my question is clear and if not
let me know I will try to clarify more.

TIA
Wally Steadman

 

[Wally Steadman]

I think I figured it out with the SIZE TO FIT FORM.

 

[Wally Steadman]

Thought I had it figured out with the size to fit form, but next time I
opened the form up, it was the size of the window and I had to do Size to
fit form again. Since users will be inputting the data, I don't want them
to have to go to Windows>Size to fit form each time. Argh, I know this is
something simple and I am missing it

 

[Wally Steadman]

That didn't work like I thought. Argh

I think I figured it out with the SIZE TO FIT FORM.

 

[tina]

in the form's Load event procedure, add a Restore command, as

DoCmd.Restore

hth

 

[Rick Brandt]

Thought I had it figured out with the size to fit form, but next time
I opened the form up, it was the size of the window and I had to do
Size to fit form again. Since users will be inputting the data, I
don't want them to have to go to Windows>Size to fit form each time. Argh, I
know this is something simple and I am missing it

The form has a property named Auto Resize. Set that to Yes and the form will
adjust its window to match the form dimensions automatically when it is opened.
Take note though that this will not happen when you go from design view to
normal view, but it will happen when you open the form when it is closed
entirely.