Sizing Forms

[Guest]

Dear Access Form Coders
I'm having difficulties with creating a form and sizing it to stay at a
given size. I have set AutoResize to No and AutoCentre to Yes. OK, yes I
have read the help menu on this and it warns that Access will "clip" the form
unless I save it in form view mode. I have done this twice and I continue to
get users on our network complaining that the forms have shrunk themselves.
I don't want the forms to be maximised but this appears to be the only
answer, i.e. coding the form to maximise when opened and maximise when
activated. Surely I'm entitled to design forms to a nice balanced size and
not have this aberrated behaviour taking place? Can anyone help me tame the
beast so I can run my forms at the designed size?

 

[Marshall Barton]

I'm having difficulties with creating a form and sizing it to stay at a
given size. I have set AutoResize to No and AutoCentre to Yes. OK, yes I
have read the help menu on this and it warns that Access will "clip" the form
unless I save it in form view mode. I have done this twice and I continue to
get users on our network complaining that the forms have shrunk themselves.
I don't want the forms to be maximised but this appears to be the only
answer, i.e. coding the form to maximise when opened and maximise when
activated. Surely I'm entitled to design forms to a nice balanced size and
not have this aberrated behaviour taking place? Can anyone help me tame the
beast so I can run my forms at the designed size?

The way I deal with this is to open the form in design
view, switch to form view, size and position the form the
way I want it, switch back to design view, click the Save
button and close the form.

Remember that any time you modify the form's design, any
change to the form's size or position will be saved along
with your changes.

If you are doing this so often that it's annoying, then you
can use DoCmd.MoveSize in the form's Load event.

 

[Guest]

Thanks Marshall

I'm sure that I have followed the help menu instructions closely. I have
done what you said, i.e. I have made non-sizing changes in Design View,
opened it into Form View then made changes to the size of the form and
clicked the Save button. Yet, users on our network telling the forms were
being clipped by Access, as per the Remarks in AutoResize help. As I said,
the users are telling me this is happening and I have seen it. I looked up
my Access Developers Handbook 2002, Litwin, Getz and Gunderloy. It offered
information about FormResize but to be honest I'm not up to the that level.
Possibly it is different screen resolutions that people are using, I'm not
sure, anyway if you can help that would be great.

 

[Marshall Barton]

I'm sure that I have followed the help menu instructions closely. I have
done what you said, i.e. I have made non-sizing changes in Design View,
opened it into Form View then made changes to the size of the form and
clicked the Save button.

You should switch back to design view before clicking the
Save button.

Yet, users on our network telling the forms were
being clipped by Access, as per the Remarks in AutoResize help. As I said,
the users are telling me this is happening and I have seen it. I looked up
my Access Developers Handbook 2002, Litwin, Getz and Gunderloy. It offered
information about FormResize but to be honest I'm not up to the that level.
Possibly it is different screen resolutions that people are using, I'm not
sure, anyway if you can help that would be great.

You need to see what users are talking about, it is not
clear what they mean by "forms were being clipped".

Did you try using MoveSize?

 

[Guest]

OK, I'll try your suggestions, I thought I had but now I'm thinking I got
mixed up on them. The "clipping" is about the form's dimension, it is not
scaling like the form doesn't become microscopic rather it is as if someone
resized the right hand side and the bottom of the form to be smaller. There
are then certain controls on the form which can't be accessed unless you
scroll across. They are resizing to a smaller size (but not shrinking as in
scaling down).

 

[Marshall Barton]

OK, I'll try your suggestions, I thought I had but now I'm thinking I got
mixed up on them. The "clipping" is about the form's dimension, it is not
scaling like the form doesn't become microscopic rather it is as if someone
resized the right hand side and the bottom of the form to be smaller. There
are then certain controls on the form which can't be accessed unless you
scroll across. They are resizing to a smaller size (but not shrinking as in
scaling down).

There is no "scaling down" in Access. AFAIK, Access will
not change the size of a form to make it fit in the Access
window either, so either you are changing the form's size in
some code somewhere, or you/users are doing it manually.

Don't forget that whenever you save the form's design, the
form's size at that time is also saved. This could happen
if a user resizes the form for whatever reason and either
clicks on the Save button or you have some code somewhere
that executes a statement like:
DoCmd.Close acForm, formname, acSaveYes
or
DoCmd.Save

If you were seeing a textbox/label where its text doesn't
fit in the control on one machine, then I would suspect that
the control's Font doesn't exist on that machine (Windows
would then use a substitute font that probably takes more
space).