This week's Office challenge tests your knowledge of Access reports. You'll also learn the solution to last week's question about automatically opening Word documents at a specific zoom percentage.
It's easy to add a line to an Access report. Lines, strategically inserted, can help separate and highlight specific data. Lines aren't always enough though. Occasionally, you'll want a stronger statement, and drawing a border around the report page might be just what you need. How do you add a border to a report page?
Last week we asked…
How can you force a Word document to open at a specific zoom setting? Word opens a document using the zoom setting in use when last saved. If you want to force a document to always open at a specific zoom setting, you'll need VBA. Cuhlig was the only one to suggest the following subprocedure:
Public Sub AutoOpen()
ActiveWindow.ActivePane.View.Zoom.Percentage = percentage
where percentage is the exact setting value. For instance, to open a document at 200%, you'd specify the value 200. If you don't know how to add code to a Word document, do the following:
If you want to specify a specific zoom level for all documents, including new ones, add the subprocedure to the Normal.dot template file.
With the document open, press [Alt]+F11 to open the Visual Basic Editor.
From the Insert menu, choose Module.
Enter the above code
Return to the Word document and save it.