Reports: portrait and landscape format

[gianina]

Hi All,

I created some reports and saved it in "Landscape" format.
These reports are opened by the press of a button.
The problem is that every time I open the reports they open in "Portrait" format !

Is there a way to fix this ?

Thanks.

 

[PHV]

In the Open event procedure of the Report you may try this:
Me.Printer.Orientation = acPRORLandscape

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[gianina]

Thanks PHV,

I know this might sound dummy for you but I am not familiar with codes and I don't know where to go exactly to enter the code you provided.

If you could guide me a little bit would be awsome.

Thanks again.

 

[payback]

Make sure you have all service packs installed. This was a known issue in one of the Access versions.

 

[rjoubert]

1. Open your report in Design View
2. open the properties of your report (properties button on toolbar Or View - Properties from the menu)
3. click on the Event tab of your properties
4. Click into the On Open event
5. click on the ellipsis button
6. Select Code Builder from the Choose Builder list
7. Paste the line of code that PHV gave you

Your code should look like this...

Private Sub Report_Open(Cancel As Integer)
Me.Printer.Orientation = acPRORLandscape
End Sub

 

[gianina]

rjoubert,

I followed your steps and when tried to open the report the following error message comes up:

"Compile error:
Method or data member not found"

What should I do ?

Thanks.

 

[gianina]

payback,

How can I check if I have all service packs installed ???

Thanks.

 

[rjoubert]

Do you have a printer setup? If you are not connected to a printer, I'm thinking that line of code won't work. I could be wrong...

 

[gianina]

rjoubert,

I am connected to a network printer.

 

[PHV]

What is the complete access version showed when you click the About option of the help menu ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[gianina]

PHV,

Microsoft Access 2000 (9.0.3821 SR-1)

 

[rjoubert]

I don't think Me.Printer is available in Access 2000.

 

[PHV]

OK, my suggestion may not work with such old application, sorry.

How can I check if I have all service packs installed
Go to the OfficeUpdate site of Microsoft.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[rjoubert]

I'm not sure if this applies to you, but it's worth checking out...

http://support.microsoft.com/kb/240826/

 

[PHV]

Another useful link for you:

http://support.microsoft.com/kb/276367/

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886