sixe of print preview

[Steve S]

When I open a report the default size option of the printpreview is set to
50% which is unreadable. the user has to select 100% for each an every
report which is a pain. How can I change the default to 100%? This only
happens on one PC so I am fairly sure it is a toolbar setting and not
comething I can control within the application.

Steve

 

[Allen Browne]

If this is Access 2003, open the report in design view, and set the
AutoResize property to No.

It's in the Properties box (View menu), on the Format, tab, when looking at
the properties of the Report (not of a text box.)

 

[Steve S]

Thanks much. That worked. the only problen is that i have 24 reports in
this application that have to be changed every time is download a new version
to the user. I have access 2000 and some of them have 2003. any shortcuts
other than me using 2003?

Steve

 

[Allen Browne]

You can programmatically loop through the AllReports collection, OpenReport
in design view, assign False to this property, and Close (with save).

The loop looks like this:

Function ReportProps()
Dim accobj As AccessObject

For Each accobj In CurrentProject.AllReports
Debug.Print accobj.Name
Next
End Function