Sizing of Modal Form

[robert d via AccessMonster.com]

I'm having a problem with the sizing of a modal form. The modal property is
not set, but the form is opened using the acDialog option.

When I resize it and then save it that works. But, as I'm developing, if
there is an untrapped error, the form goes back to some size (which I don't
even know how it is determined), where the two buttons at the bottom of the
form are missing. I have this form currently setup with a thin border, so it
can't be resized on the screen in run mode.

I guess I don't understand the proper method for resizing a form with a thin
border. Also, perhaps using the acDialog option is different than setting
the modal property. Perhaps I should be setting the popup property as well.

If someone could give me a step-by-step procedure, I would appreciate it.
Also, once resized, I want it to stay at that size. Right now this is
driving me crazy, as I'm constantly having to resize the form.

Thanking you in advance.

 

[Ken Snell \(MVP\)]

To size what the form will be when opened in popup or dialog mode, easiest
thing to do is this:

Set the border to Resizable while in Design view. Switch to form view. Click
the Restore button to make it the smaller size. Size the borders to what you
want and the location you want. Press Ctrl+s on the keyboard to save the
settings. Switch back to Design view. Change the border to Thin.

If you're using ACCESS 2002 or higher, there is an AutoSize property that
works pretty well too. But if you want your settings for the border sizing
to stick, be sure that that property is set to No.

 

[Albert D.Kallal]

Ken has given you the *exact* process that I have used to size forms for
years...

The *very* important tip here is to turn off the auto-resize (set it to no).

 

[robert d via AccessMonster.com]

Thanks, guys.

I've implemented Ken's method and it seems to work fine. Wouldn't you know it,
though, the code is now pretty much error free and it was the errors that
caused resizing. I'll need to "raise" some errors just to complete my
testing. I'll report back if I have any continuing problems.