PDA

View Full Version : Set the width and hieght of a report



daniels012
11-05-2008, 12:03 PM
What code can I add (and where) to make a report's height and width be set to specific sizes?

Michael

nepotist
11-05-2008, 12:20 PM
Did you try page setup in design view.

Guess you are talking about the type of paper that you want your report to be printed on.

daniels012
11-05-2008, 12:27 PM
Actually when I open the report in preview It is about 2 inches tall and 5 inches wide.
I want it to open about 7 inches tall and 6.5 inches wide

Michael

Carl A
11-05-2008, 02:26 PM
The Height property applies only to form and report sections, not to forms.

Width
me.width = 6.5

daniels012
11-05-2008, 02:43 PM
Carl,
This did not work.
I entered it in the reports OnOpen coding.
Ideas!
Michael

Carl A
11-05-2008, 03:20 PM
Well doh!

Its in twips 9660 should get you what you need.

Sorry about that