Completely display a form

[Guest]

How do you make sure a form is fully displayed (no scroll bars, not maximized)?

I have several forms (unbound) which are used to display sorting options for
reports. Upon a button click, the form then opens the report with the
requested sort.

The forms are small enough to fit on any screen. They open fine on my
system, but when I open the form from a computer using the Access runtime, a
portion of the form is open and the user must drag the border wider to see
the entire form. When the form is closed and reopened, the user must drag the
border again. The forms are usually opened from the switchboard "Open Form in
Edit Mode".

From the runtime, there is no "file>save" option to save the form once the
size has changed. I'd prefer to do it programmatically anyway (or in the form
properties).

An example of the form can be viewed at
www.comicbookpullfile.com/temp/dynamicgroupingsform.htm

You can see how the circled form cuts off some of the controls. I could
maximize, but would rather not as the form is not that large. It could have
to do with differences in resolution, but I would think there is some
property or programmatic ability to make the form show completely.

Remember that this is on the Access 2003 runtime, so the user can't change the
size of the form and save it.

I previously got the suggestion to set the "auto resize" set to
"yes" but it did not make a difference.

thanks,
James

 

[Rick Brandt]

How do you make sure a form is fully displayed (no scroll bars, not
maximized)?

Set the AutoResize property to Yes.

 

[Guest]

Wow, that didn't take long for you to suggest what was suggested last time
which doesn't appear to work.

I've changed the property on all the forms in question and it doesn't make a
difference on the runtime.

Any OTHER suggestions?

thanks,
James

 

[Rick Brandt]

Wow, that didn't take long for you to suggest what was suggested last
time which doesn't appear to work.

I've changed the property on all the forms in question and it doesn't
make a difference on the runtime.

Any OTHER suggestions?

From Access 97 help on the AutoResize property...

**************************************************************
If you make any changes in Design view to a form whose AutoResize property is
set to No and whose AutoCenter property is set to Yes, you should switch to Form
view before saving the form. If you don't, Microsoft Access clips the form on
the right and bottom edges the next time you open the form.
***************************************************************

Sounds pretty much like your problem.

 

[Albert D. Kallal]

What you want to do is freeze your form size so users do not have to
re-size, and CAN NOT resize....

First, Try setting auto-resize = no
(if you leave this yes, then ms-access will try to re-size...you DO NOT want
that!!!).

Ti fix a form to the correct size:

while in design mode, change border style to sizeable.

Now, flip into view mode:

While viewing the form I re-size it until it is just
right. I then whack ctrl-s. I then open the form up in deign mode and change
the border style to thin, then save again.
Now, users can't change it, it will ALWAYS open to your design size.

It is a VERY good idea to set auto-center = yes, and don't forget to set
auto-resize = no

That should help you..

If you need to change the size of the form, then you have to open the form
up in design mode, and change the border style back to sizeable. Then while
viewing, re-size until you are happy (then ctrl-s). Again, back in design
mode..change
border type back to thin to "lock" the size.



I done the above for years...and it works well for me...

 

[Guest]

Albert and Rick,
thanks to both of you for the input. I tried both of your suggestions.
Here's what I've found out.

Rick -
Saving the form works great on the development computer. If I copy the .mdb
to my test computer which only has the 2003 runtime the form displays fine.
If I then package the .mdb to make an .mde and open the form on the test
computer, the form is now clipped as you found in the documentation.

Albert -
I tried your method and the form displays fine even after the .mde packaging
procedure. I do have to slightly oversize the form before I save it because
it shrinks slightly once I change the border style.

Looks like the problem is solved, thanks again.

James Deckert