Changing size of continuous form

  • Thread starter Thread starter nartla
  • Start date Start date
N

nartla

Hello,

I created a continuous form in an Access VBA application.
I have data displayed in my continuous form (let say it is displayed
in the "Data" part of the form).
It has also a footer and a header.

But when the data is displayed, the form is half the size in height of
the other forms of the app. There is enough data to have the form the
same size of the others, but for this, I have to resize it manually.

Is there a property I could change to make the data part of the
continuous form more high, without modifying the header and the
footer ?

Thank you.
 
nartla said:
I created a continuous form in an Access VBA application.
I have data displayed in my continuous form (let say it is displayed
in the "Data" part of the form).
It has also a footer and a header.

But when the data is displayed, the form is half the size in height of
the other forms of the app. There is enough data to have the form the
same size of the others, but for this, I have to resize it manually.

Is there a property I could change to make the data part of the
continuous form more high, without modifying the header and the
footer ?
Click to expand...


The trick here is to set the height of the form to whatever
you want. This can be done in code by setting the form's
InsideHeight property or by using the MoveSize method.

OTOH, if you do not want to change the height dynamically,
you can just make the form's design the desired height and
save the form.
 
OTOH, if you do not want to change the height dynamically,
you can just make the form's design the desired height and
save the form.
Click to expand...

When you design a continuous form, and if you want each data line to
be just under the other, you have to make the central part of the form
just the size of the data line, since this part will be repeated over
and over to display the data.

In my case, I have 20 lines of data displayed, and a vertical slider
in the right of the form to let me see the rest of the data, but what
I'd like is 30 lines of data displayed in the form before the vertical
slider appears.
 
The trick here is to set the height of the form to whatever
you want. This can be done in code by setting the form's
InsideHeight property or by using the MoveSize method.

Marsh
MVP [MS Access]
Click to expand...


Thank you very much for your help. InsideHeight is exactly what i was
looking for.
 
nartla said:
When you design a continuous form, and if you want each data line to
be just under the other, you have to make the central part of the form
just the size of the data line, since this part will be repeated over
and over to display the data.

In my case, I have 20 lines of data displayed, and a vertical slider
in the right of the form to let me see the rest of the data, but what
I'd like is 30 lines of data displayed in the form before the vertical
slider appears.
Click to expand...


The "central part" of the form is called the Detail Section.
You set this to whatever height is needed to display your
controls. When a form is opened in continuous view, its
height is the same height as its **design window**. The
space is then allocated to the form header and footer
sections and any remaining space is divided up into as many
instances of the detail section as will fit in the remaining
space.

All that means that you can make the form display as many
records as you can get on your screen just be making the
form's **design window** taller and saving the form's
design.
 
Back
Top