Add space to a form

K

Kylie

I currently have a form which equates to two-sides of an A4 sheet. However,
there is now further information that needs to be inputting on the form and I
need to increase the size of the form to three-sides of an A4 sheet. How do
I increase the 'length' of my form? I am unable to change the 'height'
number.

I am in the middle of this at work so any help asap would be much appreciated!

Thanks.
 
J

John Vinson

I currently have a form which equates to two-sides of an A4 sheet.
Click to expand...

Ummm...

Forms are designed for *screens*, monitors - not for paper. Why is it
important that the onscreen Form be the same size - or even have any
relationship - to a piece of paper?

If you are printing a Report, *that* will need to match the paper; and
you can open it in design view and drag the edges out to the maximum
size of any report, 22 by 22 inches.
However,
there is now further information that needs to be inputting on the form and I
need to increase the size of the form to three-sides of an A4 sheet. How do
I increase the 'length' of my form? I am unable to change the 'height'
number.
Click to expand...

How are you trying to do so?

John W. Vinson[MVP]
 
K

Kylie

Hi John

Yes - I realise that it seems strange that we are printing reports, but we
have a large number of fields (and therefore a large form) that we wish to
display on paper as a paper record. It is much easier for users to simply
print a single record, rather than have to run a report.

I have tried changing the paper size, and also on the rulers at the sides of
the actual form itself.
 
J

John Vinson

Hi John

Yes - I realise that it seems strange that we are printing reports, but we
have a large number of fields (and therefore a large form) that we wish to
display on paper as a paper record. It is much easier for users to simply
print a single record, rather than have to run a report.
Click to expand...

There's no need to "run" a Report. You can save the Form as a report,
and put a command button on the Form to launch the report, passing the
unique ID of the current record in the OpenReport line's
WhereCondition parameter.

That said... you can make the form bigger, up to the 22" x 22"
hard-and-fast limit, by just dragging the edge of the report in design
view. Are you exceeding that limit? If so, then you may be out of luck
and will be obliged to go to the report method.

John W. Vinson[MVP]
 
Top