Sset the height of a form passed the inbuilt limit?

  • Thread starter Thread starter Mark B
  • Start date Start date
M

Mark B

Does anyone know how to set the height of a form passed the inbuilt limit?

I want to set the height of a graphical form so that it will fill a portrait
page when printing.

When the screen resolution is <= 1024x800, the InsideHeight property is
capped by Access so that the height is reduced.

Perhaps there is an API to push past this limit?

Thanks for any help.

Mark
 
On Mon, 6 Oct 2003 15:34:12 +1300, "Mark B" <remove_from
Does anyone know how to set the height of a form passed the inbuilt limit?
Click to expand...

You cannot.
I want to set the height of a graphical form so that it will fill a portrait
page when printing.
Click to expand...

Forms are for onscreen use. Reports are for printing. Any way you can
duplicate the desired display on a Report?
When the screen resolution is <= 1024x800, the InsideHeight property is
capped by Access so that the height is reduced.
Click to expand...

It's limited to 22", and AFAIK there is no way to get around this
limit.
 
I should have worded the question a bit better.

The form height _is_ within the 22 inch limit, but when printing, Access
looks at the screen resolution to see if the form fits on one CRT. So if the
resolution is at 640x400 the form that will printout will be cropped
vertically to a much smaller height than would be printed at 1600x1200.

In my case the same form prints out fine if I set the screen resolution to
=1280x1024, but is too short if the user has their screen at anything less,
Click to expand...
e.g. 800x600. E.g. without resizing the form, just by performing the
following actions, the printout will be different:

- Set the screen to 1600x1200
- Open the form
- Stretch it (by dragging the corners) to a shape that resembles US-Letter
portrait
- File, Print.... wholla the form prints out nicely filling the US Letter
paper.

Now if I simply change the resolution to 800x600 without touching the form,
and then click File, Print..., the form gets cut off short when it is
printed. Access crops the height to the screen resolution height.

I thought there may be something like
http://support.microsoft.com/default.aspx?scid=kb;en-us;84066 that I could
use.

Regards
Mark
 
Mark said:
I should have worded the question a bit better.

The form height is within the 22 inch limit, but when printing, Access
looks at the screen resolution to see if the form fits on one CRT. So
if the resolution is at 640x400 the form that will printout will be
cropped vertically to a much smaller height than would be printed at
1600x1200.

In my case the same form prints out fine if I set the screen
resolution to
e.g. 800x600. E.g. without resizing the form, just by performing the
following actions, the printout will be different:

- Set the screen to 1600x1200
- Open the form
- Stretch it (by dragging the corners) to a shape that resembles
US-Letter portrait
- File, Print.... wholla the form prints out nicely filling the US
Letter paper.

Now if I simply change the resolution to 800x600 without touching the
form, and then click File, Print..., the form gets cut off short when
it is printed. Access crops the height to the screen resolution
height.

I thought there may be something like
http://support.microsoft.com/default.aspx?scid=kb;en-us;84066 that I
could use.

Regards
Mark
Click to expand...


As John says, use a Report for printing - that's what Reports are for;
Forms don't print well and are not meant for that.

hth

Hugh
 
Back
Top