AutoResize on a continuous form

[ArielZusya]

I've got two continuous forms in an access 2007 database application I've
created. They've both been set "Auto Resize" and "Auto Center" to "Yes" and
while both seem to auto center, only one seems to auto resize. Specifically,
on a computer where the app is run locally, and which has a monitor that is
rotated to portrait orientation with 1024 x 1280, even if there is only one
row of data to display on the form that seems to auto resize properly, the
form fills the height of the screen. On the same computer setup, however,
with the form that doesn't seem to resize properly, even if there are
hundreds of rows of data, it only shows five or six rows. Both forms are set
to have a dialog border so they are not user resizable. If I manually change
the height of the form in design view that isn't cooperating I can
temporarily resize the form to fill the height of the screen but it goes back
to the 5 or 6 row view when the program is next opened (thanks to the auto
resize). I would just turn off auto resize but I'd like to create the front
end app universally and allow it to be installed on a number of systems with
different monitor and resolution configurations without additional code if I
can avoid it. Any thought on how I can get the form that isn't resizing to
fill the height of the screen to do so automatically? Thanks!

 

[Marshall Barton]

I've got two continuous forms in an access 2007 database application I've
created. They've both been set "Auto Resize" and "Auto Center" to "Yes" and
while both seem to auto center, only one seems to auto resize. Specifically,
on a computer where the app is run locally, and which has a monitor that is
rotated to portrait orientation with 1024 x 1280, even if there is only one
row of data to display on the form that seems to auto resize properly, the
form fills the height of the screen. On the same computer setup, however,
with the form that doesn't seem to resize properly, even if there are
hundreds of rows of data, it only shows five or six rows. Both forms are set
to have a dialog border so they are not user resizable. If I manually change
the height of the form in design view that isn't cooperating I can
temporarily resize the form to fill the height of the screen but it goes back
to the 5 or 6 row view when the program is next opened (thanks to the auto
resize). I would just turn off auto resize but I'd like to create the front
end app universally and allow it to be installed on a number of systems with
different monitor and resolution configurations without additional code if I
can avoid it. Any thought on how I can get the form that isn't resizing to
fill the height of the screen to do so automatically?

AutoResize just sizes the form to the total of the form's
section's design view heights. For continuous/datasheet
form view it displays as many records as will fit in the
available design view eight and adjusts to not show part of
a detail.

If you want to make your design view size stick, save the
form before switching to form view.

 

[ArielZusya]

Thanks for your response. I had assumed that was how auto resize worked but
that is not what is happening with my two forms and I can't figure out why.
To be clear, even the form that I am describing as not "working" expands
large enough to not cut off the bottom row of record but the other form seems
to be expanding much larger to match the size of the monitor (and only does
this on systems with large monitors). In terms of the sizing in design view
they are currently both roughly the same size but when I switch to the active
view the form that I see as "working" (though I recognize that it may not
actually be related to auto resize and how auto resize is supposed to work
from what you're saying) gets bigger to fill the height of the monitor and
the form that isn't "working" doesn't, even though there are far more records
to display on the form that isn't working. Any idea why that would be?

Ultimately, what I'd like to do is cause each form to resize to fill the
screen in terms of length of the form (height of the screen) but not
maximize. In other words get the form that isn't "working" to match the way
the form that is "working" behaves. Is there some way of doing that which
will be dynamic enough to work well on different sized monitors? Thanks!

 

[Marshall Barton]

For form's in continuous/datasheet view, if you make the
form the size you want in design view, then save and close
the form, it should open the next time pretty close to the
same size. I fogot to mention the close part of this
before, but IME, that's a ctitical step.

Getting the form to utilize the full height of any size
monitor is an entirely different can of worms. See
http://www.mvps.org/access/api/api0012.htm for the first
step. I have not done this, so someone else will have to
jump in with the details or you'll have to start a new
thread with this specific question.