How do I print access 2000 report with landscape view every time?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I open my access 2000 report, I need its default orientation to be
landscape. Right now, I have to go to file->page setup-> and set it to
landscape every time I open my database. Is there some VB code that can
resolve this issue? Also, when I print the report, it prints using my default
printer, is there a way to have it bring up the same printer options box that
I would get if I were to go to File->Print? Thanks.
 
Open the report in Design View. Goto File, Page Setup, and
change the orientation. Save the report design.

To bring up the File, Print menu item, select the object in the
database window, then use RunCommand:

docmd.SelectObject acReport, "myReport"
docmd.RunCommand accmdprint

(david)
 
I have a similar problem, except that when I open the reports using a command
button, it will revert to letter size instead of legal size. This happens
when others open the database as well. Is there a way I can add a command to
the VB of the command button so that when users open the report it will
always show up in legal view instead of letter view?
 
Access reports will always revert to default
if the printer is not installed correctly.

The printer driver has to match exactly or
the report will revert to default.

Access 2000 should always have at least service
pack 1, and Name AutoCorrect should be turned off.

(david)
 
Back
Top